29 queries on Forumhome !!!

[Admin]

Oh look, 27!

[Jawelin]

Well. My bumps made you workin' harder !!!

Now a simple question: how to count more totals all at once in the same query ?

[Admin]

Oh my god, 25!

[Admin]

I don't believe this, 23!

What do you mean Jawelin?

[Jawelin]

As I told you, my questions made you working on optimizing queries.

The obvious followin question is : could you give me/us/everybody any hint to keep all the hacks you have installed on the index.php page and, same time, join together some queries to make their total number much lower ?

Nakkid said 40 queries are absolutely too much. Now I have 39-42 depending on some forumbit features...
I absolutely would drop them down !



Thank you

[Admin]

How about showing me your index page, so I can see where all these queries are coming from.

[Jawelin]

Originally posted by FireFly
How about showing me your index page, so I can see where all these queries are coming from.

Sure.
Here's my index.php 'query collection' (queries only, of course), as you requested.

[Jawelin]

Just a curiosity about templates (performance issue), I just posted in vb.com too:
I understood that, if I include templates in "$templatesused", they will be loaded at page loading time, saving a query later when they would be actually used.
1) Is this query actually skipped or simply is not mentionned in querycount ?
2) Should I pre-load all templates, even their execution is if-conditioned ? What could be the right measure to choose whether or not ?
3) Is there a memory overload when I charge it with all templates ? If I evaluate them only when actually used, they will be unloaded right after or will stay in mem ?

Thanks.

[Admin]

You want to load all queries once, in $templatesused. Then when gettemplate() is called, it won't call the database but get the template from the cache, which is created at the beginning.
ALWAYS use $templatesused, you have no idea how helpful it is.

I meants to see your index.php?explain=1 page, it will tell me more.

[Jawelin]

Originally posted by FireFly
You want to load all queries once, in $templatesused. Then when gettemplate() is called, it won't call the database but get the template from the cache, which is created at the beginning.
ALWAYS use $templatesused, you have no idea how helpful it is.

I meants to see your index.php?explain=1 page, it will tell me more.

Thanks for the tip about templates. I'll do it, even for if-conditioned templates ... :squareeyed:

Sorry: didn't understand about index.php... Btw, I'm using vb 2.2.5 with the updated db_mysql.php and /index.php?explain=1 doesn't work any more....
:hurt:

Thanks again