Oh look, 27!

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

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

Oh my god, 25!

I don't believe this, 23!

What do you mean 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 !

:p

Thank you

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.

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.

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