Posted on: 04/09/03 03:28pm
By: vinny
I've gone hunting through the code again trying to reduce the number of database calls and improve performance. I've found a few things that, when combined, can increase performance for the geeklog index page by about 5-10%. More details about the improvements and code can be found on
my website[*1] .
Unfortunately, the improvements are not as significat as the previous ones[*2] . Therefore, unless you're really interested in code/database optimization issues or feel you need to eek out a little more performance for your site I wouldn't necessarily recommend spending the time hacking these changes into your Geeklog site.
Enjoy, Vinny
More Performance Enhancements
Posted on: 04/09/03 07:52pm
By: alinford
You continue to Rock!!
Easy updates that worked th first time and showed a nice speed improvement. Thanks.
More Performance Enhancements
Posted on: 04/10/03 02:28am
By: Anonymous (Anonymous)
Giant increase in speed... well done.
Around 50-60% for me.
More Performance Enhancements
Posted on: 04/10/03 11:09am
By: rawdata
I just added your enhancements. There's some sort of bug in the COM_showTopics function because when I add this it makes all my topics disappear in the menu. When I remove it, they reappear. I'll try later on today to figure out what's causing it.
Thanks for focusing on performance improvements.
More Performance Enhancements
Posted on: 04/10/03 01:19pm
By: vinny
This might be a dumb bug that I didn't see because of my MySQL configuration. Try changing both occurances of:
$A['topic']
to
$A['t.topic']
and see if that works, if it does I'll update the code on my webpage immediately. If it doesn't I'll keep looking into it, though to investigate further I may need to sneak a peek at your topics and stories tables.
Thanks for the input,
Vinny
More Performance Enhancements
Posted on: 04/10/03 01:22pm
By: vinny
I take it back, that shouldn't fix the problem after all. If you have the (total/submission) numbers enabled are they showing up?
-Vinny
More Performance Enhancements
Posted on: 04/10/03 01:52pm
By: rawdata
The numbers disappear as well. What's really odd is the only topic that stays visible is the one labeled Geeklog. When I tried the $A['t.topic'] suggestion that made Geeklog disappear too, but the numbers for it stayed.
I'll find the little sucker.
More Performance Enhancements
Posted on: 04/10/03 03:07pm
By: rawdata
Okay, I figured this out. On my test site, I had deleted all the stories under all the different topics except for one -- Geeklog. Apparently, you redesigned the script so it only displays a topic if it has at least one story is listed under it. That's why all my topics disappeared except for the one. When I added stories back to the others, all the topics reappeared.
If you intentionally designed the script this way, then it's not a bug. Just seemed like one since I wasn't expecting this but I have no problem with this approach.
More Performance Enhancements
Posted on: 04/10/03 07:19pm
By: vinny
Ooops. I'll get that fixed. My SQL is a little off. Probably be done in the next 3-4 days.
-Vinny
More Performance Enhancements
Posted on: 04/10/03 08:38pm
By: vinny
OK, I have it fixed now. If you grab the new copy it should work just like the old COM_showTopics did...unless I messed something else up.
-Vinny
More Performance Enhancements
Posted on: 04/11/03 05:38am
By: rawdata
Yes, that fixed it. I kinda like the other approach though once I understood what it was doing.
)
Thanks.