Page 1 of 1

huge number of mysql queries

Posted: Tue Mar 08, 2005 8:22 pm
by ploc
using 48 SQL queries

I've just loaded the home page of the site I am maintaining and I discovered the following thing hidden at the end of the source code :



Don't think that 48 sql queries and nearly 3.5 second are huge for generating a single page ?

Woudln't it be a priority yo optimize the core of cmsmadesimple in order to be less relying on the database ?

But maybe that's just a dumb question...

Re: huge number of mysql queries

Posted: Tue Mar 08, 2005 8:26 pm
by Ted
But what happens after you reload it?  The caching should kick in and severely decrease the # of queries.

Re: huge number of mysql queries

Posted: Thu Mar 10, 2005 10:40 am
by ploc
Right, the second time, some informations seem to have been cached.

But whatever, 48 sql queries for a single page, isn't it huge ?

Re: huge number of mysql queries

Posted: Thu Mar 10, 2005 1:42 pm
by Akrabat
The stock template uses 8 sql queries.

Which modules are you using?

Re: huge number of mysql queries

Posted: Thu Mar 10, 2005 8:37 pm
by Ted
There would have been one query per item in a menu in versions previous to 0.9.2.  I really can't imagine it still doing that now.