> The performance of the application is VERY bad: build time > for the pages is between 8 and 30 secs. Although there are > very many SQL queries executed (abt. 40 per page), this > seems not to be the problem, because cpu utilization of > the database server is very low.
As a wagering man, I'd put my money on these queries. That's a lot of database interaction, and keep in mind that it takes time to move recordsets back and forth over the wire. Do you need to execute all these queries per page? What happens to query execution times under load? > I know there are many threads covering this issue, but I > couldn't find a solution at all. Could changing to Apache > be a solution if this is a IIS related error? It's highly unlikely that this has anything to do with your web server. The reason that you're not likely to find a simple solution to this online is just that it usually doesn't have a simple solution - you're doing too much work in your application, and you might have to rethink some portions of your application. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
