Welcome to Geeklog, Anonymous Monday, May 20 2024 @ 07:42 am EDT

Geeklog Forums

More Performance Enhancements


Status: offline

vinny

Site Admin
Admin
Registered: 06/24/02
Posts: 352
Location:Colorado, USA
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

 Quote

Status: offline

alinford

Forum User
Regular Poster
Registered: 01/06/03
Posts: 96
You continue to Rock!! Easy updates that worked th first time and showed a nice speed improvement. Thanks.
 Quote

Anonymous

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

Status: offline

rawdata

Forum User
Full Member
Registered: 02/17/03
Posts: 236
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.
 Quote

Status: offline

vinny

Site Admin
Admin
Registered: 06/24/02
Posts: 352
Location:Colorado, USA
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
 Quote

Status: offline

vinny

Site Admin
Admin
Registered: 06/24/02
Posts: 352
Location:Colorado, USA
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
 Quote

Status: offline

rawdata

Forum User
Full Member
Registered: 02/17/03
Posts: 236
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.
 Quote

Status: offline

rawdata

Forum User
Full Member
Registered: 02/17/03
Posts: 236
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.
 Quote

Status: offline

vinny

Site Admin
Admin
Registered: 06/24/02
Posts: 352
Location:Colorado, USA
Ooops. I'll get that fixed. My SQL is a little off. Probably be done in the next 3-4 days. -Vinny
 Quote

Status: offline

vinny

Site Admin
Admin
Registered: 06/24/02
Posts: 352
Location:Colorado, USA
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. Smile -Vinny
 Quote

Status: offline

rawdata

Forum User
Full Member
Registered: 02/17/03
Posts: 236
Yes, that fixed it. I kinda like the other approach though once I understood what it was doing. Surprised!) Thanks.
 Quote

All times are EDT. The time is now 07:42 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content