Reducing Queries
 

Can someone point to me who had a hack that reduces forumhome's queries down by 2? Think it was Erwin who showed how it was done, but I can't seem to find that thread.

Currently have 9 queries and no uncached templates. But I had it down to 7 before with that mod (it's a new install to test new hacks, so don't want to reimport an already modded copy of vB).

With 9 queries it's taking 0.05 seconds to generate the page, but with 7 that can come down to 0.03.

Chris

was this a vb2 hack?

Don't believe it was, since I used it on 3.0.1.

Got it off of a thread where members were trying to get templates cached (why Erwin came to mind, with caching his Microstats templates).

It eliminated 2 extra queries and knocks off around 0.02 off the page generation time.

Just can't find that thread now. Would like to rebump it, as it's a little optimization that does the trick. ;)

Chris

hmm, i don't know that hack.

normally the require global.php already takes 8 queries, so it would be hard to get to 7 with just changing index.php queries.

i may be wrong, but i don't think so ^^

9 quierys is nothing to be worried about

Found it! Erwin was the correct author, but it wasn't about templates itself....

Total Number of Users Online Now on Every Page
https://vborg.vbsupport.ru/showthread.php?t=59722

Little hack can reduce the index.php queries down by 1 or 2.

Chris

as i said 9 is nothing to worry about