-
AuthorPosts
-
el patron Friend
el patron
- Join date:
- October 2009
- Posts:
- 67
- Downloads:
- 0
- Uploads:
- 0
- Thanks:
- 14
- Thanked:
- 4 times in 1 posts
July 4, 2010 at 6:01 pm #152274One of our sites has 10k articles and growing really fast. most_read logic of chasing a section/category db thread to it’s end for the ‘most read’ is a big performance issue for us (and you).
We are unable to run ‘most read’ joomla core or the much cooler JA bulletin. We really love JA bulletin BUT we can no longer run ‘tipico’ ‘most read’ based modules.
We need to limit the date that ‘most read’ logic will go back in time looking, preferably we could just limit it by days, (90 days for example). But if you have a better solution, let’s hear it as we want JA Bulletin running on all section/cat blog pages (by particular section/cat), we think it rocks…we want those 25/25 thumbnails!
Winning community member solution to ja bulletin will receive $25.00 via PAYPAL.
PLEASE HELP IS BE ALL WE CAN BE…:D
p.s. we needed this six months ago!gray Friend
gray
- Join date:
- October 2009
- Posts:
- 957
- Downloads:
- 0
- Uploads:
- 17
- Thanks:
- 28
- Thanked:
- 292 times in 230 posts
July 5, 2010 at 2:33 pm #349007Try my hacked version of JA Bulletin. It has the option of limiting articles by dates (but I haven’t checked the speed).
1 user says Thank You to gray for this useful post
el patron
- Join date:
- October 2009
- Posts:
- 67
- Downloads:
- 0
- Uploads:
- 0
- Thanks:
- 14
- Thanked:
- 4 times in 1 posts
July 5, 2010 at 6:26 pm #349028Hi Gray,
Thanks so much for the tip. I’ve looked at the hack and it appears the like the logic will still read all the articles, i.e. doesn’t stop reading the DB articles past the ‘Period of Novelty’. Do you think our analysis of the helper.php is correct?
gray
- Join date:
- October 2009
- Posts:
- 957
- Downloads:
- 0
- Uploads:
- 17
- Thanks:
- 28
- Thanked:
- 292 times in 230 posts
July 6, 2010 at 5:02 am #349071The SQL query does not retrieve all articles from the DB. One of the conditions (added in the hack) is the article created date to be withing specified limits.
Still, I don’t know how in influences the speed. In some cases a direct SQL query without any conditions is quicker than the one with conditions in place.
On more point – the query takes whole article row (‘SELECT a.* FROM #__content AS a’ ) but not all content is required (for example full text of the article). Again, it could be faster than specifying exact rows to be selected…
Only tests could show what is faster.
1 user says Thank You to gray for this useful post
el patron
- Join date:
- October 2009
- Posts:
- 67
- Downloads:
- 0
- Uploads:
- 0
- Thanks:
- 14
- Thanked:
- 4 times in 1 posts
July 7, 2010 at 5:09 pm #349258Hi Gray,
Point is taken i.e. ‘that it does not retrieve all the related category articles’. But it looks like it will read through all the articles in a related category, yes?
What we want is for it the logic to stop reading when the article in that category exceeds the number of ‘freshnes’ days, i.e. not read all three years of content finding say five articles in the last say 61 days
and good point about reading entire row…ja_bulleting for example requires (depending on selection), article date, image, fp candidacy…
I as always really appreciate your feedback and guidance.
gray
- Join date:
- October 2009
- Posts:
- 957
- Downloads:
- 0
- Uploads:
- 17
- Thanks:
- 28
- Thanked:
- 292 times in 230 posts
July 8, 2010 at 5:07 am #349293I can add 2 more points:
– fields by which ordering is performed (a.created) should be indexed for faster execution
– query has set number of rows to retrieve by LIMIT statement (realized through $db->setQuery ( $query, 0, $count );), Theoretically as soon as necessary number of matching rows is found, execution of the query should be stopped.1 user says Thank You to gray for this useful post
el patron
- Join date:
- October 2009
- Posts:
- 67
- Downloads:
- 0
- Uploads:
- 0
- Thanks:
- 14
- Thanked:
- 4 times in 1 posts
gray
- Join date:
- October 2009
- Posts:
- 957
- Downloads:
- 0
- Uploads:
- 17
- Thanks:
- 28
- Thanked:
- 292 times in 230 posts
July 13, 2010 at 5:20 am #349744<em>@el patron 186212 wrote:</em><blockquote>Dear gray,
implemented the ja_bulletin hacked version on our fp today….the content folks are off having a go at it….HERE The really like the style of ja_bulletin. So far so good!
gray, please send me your paypal email address!</blockquote>
Glad to hear the it works! It was my contribution to the community. So, if you would need special hack for you, you’ll be charged separately :)))
Good luck!
Manos
Moderator
Manos
- Join date:
- February 2014
- Posts:
- 2806
- Downloads:
- 46
- Uploads:
- 56
- Thanks:
- 200
- Thanked:
- 633 times in 576 posts
July 13, 2010 at 11:33 am #349781<em>@el patron 186212 wrote:</em><blockquote>Dear gray,
implemented the ja_bulletin hacked version on our fp today….the content folks are off having a go at it….HERE The really like the style of ja_bulletin. So far so good!
gray, please send me your paypal email address!</blockquote>
Hello, el patron, your site goes realy fast, can you please sugest cache and server specs for such speed ?
el patron
- Join date:
- October 2009
- Posts:
- 67
- Downloads:
- 0
- Uploads:
- 0
- Thanks:
- 14
- Thanked:
- 4 times in 1 posts
July 16, 2010 at 9:28 pm #350107<em>@pascm 186316 wrote:</em><blockquote>Hello, el patron, your site goes realy fast, can you please sugest cache and server specs for such speed ?</blockquote>
1. mod_expires
2. mysql query_cache
3. mod_deflate (turn off joomla gzip)
4. lots of little thingsour server is nothing to brag about, dedicated 2gb.
1 user says Thank You to el patron for this useful post
-
AuthorPosts
This topic contains 11 replies, has 3 voices, and was last updated by Manos 14 years, 4 months ago.
We moved to new unified forum. Please post all new support queries in our New Forum