Reducing Queries [Archive]

ChrisLM2001

11-26-2004, 12:04 AM

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

AN-net

11-26-2004, 02:45 AM

was this a vb2 hack?

ChrisLM2001

11-26-2004, 02:55 AM

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

Xenon

11-26-2004, 01:13 PM

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 ^^

Zachery

11-26-2004, 02:38 PM

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
9 quierys is nothing to be worried about

ChrisLM2001

12-01-2004, 01:59 AM

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

Zachery

12-01-2004, 02:01 AM

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