Reducing the number of queries

[cinq]

Coding a hack and was pretty shocked to see a

Executed 35 queries

at the base of the page ( in debug mode ).
And the functonality is merely at a quater of what I expect the final page to be showing....

That's rather high ain't it, for a simple listing page.

How can one go about reducing the number of queries ?
Even outputting the base template ( WITH NO CODE ), just evaluating the nav bar, gives me 5 queries.

Am i missing something here ?

[Paul M]

It would be impossible to answer your question without seeing your code, but I notice a lot of people worry too much about sql queries. Most queries run in a few milliseconds or less and most peoples mysql is spending 80%+ of it's time doing nothing.

If you have access to you server, view the mysql processlist (or install mytop) and see what your mysql is doing - the chances are that most of the time you won't see much listed as the queries are running too fast to be caught and displayed.

[Dean C]

Chances are you have a query loop in there. Between 10-20 queries on one page is more or less an average, but chances are there are more efficient ways of doing things if you have 35

As Paul said, if you show us the code maybe we can help out a little.

[Xenon]

Also often custom hacks forget to add created templates to the template cache, so each template will produce one extra query...

[cinq]

Yep Stefan, I make sure all the templates called are in the template cache ( cos the queries count warns me if otherwise ).

Ok, perhaps I shall post the hack when fully functional, and then concentrate on query optimizations.
Gotta admit while it is looking good, the queries are rather messy.....and loop-y (Dean, you're right )

p.s query count now stands at 42 ... argh

[AN-net]

Originally Posted by cinq

Yep Stefan, I make sure all the templates called are in the template cache ( cos the queries count warns me if otherwise ).

Ok, perhaps I shall post the hack when fully functional, and then concentrate on query optimizations.
Gotta admit while it is looking good, the queries are rather messy.....and loop-y (Dean, you're right )

p.s query count now stands at 42 ... argh

possible to combine queries together?

[rake]

Originally Posted by AN-net

possible to combine queries together?

I'd rather have 3 fast queries than a big slow one.. But it depends on the query, so i can't really argue with you.

[Xenon]

the most important: clean out that loop ^^

[AN-net]

Originally Posted by rake

I'd rather have 3 fast queries than a big slow one.. But it depends on the query, so i can't really argue with you.

of course but for 35 queries some must be able to be combined

[cinq]

I think it is very possible but due to my limited knowledge, I would need help from you folks.

Will start a new thread in the near future with the code specifics for you folks to help me out