Page 1 of 1

Slow Site, Way, way, way too many SQL queries.

Posted: Wed Nov 22, 2006 7:36 pm
by pgoneill
Hmmm.  I'm sure you'll agree this is obscene:

Code: Select all

<!-- Generated in 1.013899 seconds by CMS Made Simple using 319 SQL queries -->
On that page, the modules in use are:  FrontEndUsers, CustomContent, and MenuManager.

The homepage:

Code: Select all

<!-- Generated in 0.959911 seconds by CMS Made Simple using 284 SQL queries -->
Modules: FrontEndUsers, CustomContent, piSearch, MenuManager, Calendar, News.

It's running on Win2K3, IIS6, MySQL 4.1.7 (I think), PHP 5.1.4.  I'd link, but it's an intranet with content hidden by FrontEndUsers/CustomContent.

Any suggestions?

Re: Slow Site, Way, way, way too many SQL queries.

Posted: Wed Nov 22, 2006 8:13 pm
by pgoneill
Dropped it down to 77.  Still high.  Going to try more solutions. :o

Re: Slow Site, Way, way, way too many SQL queries.

Posted: Thu Nov 23, 2006 8:25 am
by petert
pgoneill wrote: Dropped it down to 77.
How did you managed to do that?