Yeah, that's a lot of queries. Are many of them returning large datasets? How's the web server fixed for memory and CPU power? Offhand, I'd say that just because your DBMS cruises through the queries doesn't mean that the large number of them isn't a problem. CF may still have a lot of processing to do with the returned data in the course of building a page.
Jim ----- Original Message ----- From: "Martin Runkel" <[EMAIL PROTECTED]> To: "CF-Server" <[EMAIL PROTECTED]> Sent: Sunday, February 17, 2002 8:01 AM Subject: NT error 232 & low performance > Hello everybody, > > we are hosting a web application on > > Win2000 Server SP 2, > IIS 5.0, > CF 5.0 > > and have > > MS SQL Server 2000 Std. on Win2000 Server SP2 > > as a backend server (used as ODBC datasource). > > 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 > excecuted > (abt. 40 per page), this seems not to be the problem, because cpu > utiliziation of the database server is very low. > > In contrast, the cpu utiliziation of the frontend server is changing > between > 50% and 100% for about 15 seconds while building a page (cfserver.exe > process at 99%). > > In the server.log of the CF server I have tons of entries saying > > "Error number 232 occurred while attempting to write the reply to the > web > server." > > This entry is written up to 40 times PER SECOND (!!!), which could > explain > the high cpu utiliziation of the frontend, but I am not sure if this is > really the reason for the low performance which is the most serious > problem > for me. > > 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? > > > I really appreciate you help! > > > > Kind Regards, > > Martin. > > > P.S.: @Macromedia support: Please DON'T refer to any other threads. > There > ISN'T a definite solution yet...! ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
