huge number of mysql queries

For questions and problems with the CMS core. This board is NOT for any 3rd party modules, addons, PHP scripts or anything NOT distributed with the CMS made simple package itself.
Locked
ploc

huge number of mysql queries

Post 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...
Ted
Power Poster
Power Poster
Posts: 3329
Joined: Fri Jun 11, 2004 6:58 pm

Re: huge number of mysql queries

Post by Ted »

But what happens after you reload it?  The caching should kick in and severely decrease the # of queries.
ploc

Re: huge number of mysql queries

Post 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 ?
Akrabat

Re: huge number of mysql queries

Post by Akrabat »

The stock template uses 8 sql queries.

Which modules are you using?
Ted
Power Poster
Power Poster
Posts: 3329
Joined: Fri Jun 11, 2004 6:58 pm

Re: huge number of mysql queries

Post 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.
Locked

Return to “CMSMS Core”