Geeklog Forums

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.

Unfortunately, the improvements are not as significat as the previous ones. 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

You continue to Rock!! Easy updates that worked th first time and showed a nice speed improvement. Thanks.

Giant increase in speed... well done. Around 50-60% for me.

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.

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

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

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.

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.

Ooops. I'll get that fixed. My SQL is a little off. Probably be done in the next 3-4 days. -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

Yes, that fixed it. I kinda like the other approach though once I understood what it was doing. ) Thanks.