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

[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?

[pgoneill]

Dropped it down to 77.  Still high.  Going to try more solutions.

[petert]

Dropped it down to 77.

How did you managed to do that?