You could briefly enable debuging to your ip only to see where bottle necks lie.
We had major issues with some of the queries that we were doing and moved them from a cached query (in memory) to writing them to a local text file for reading. Cache queries that are unlikely to change for large periods of time. We added a cleare cache to the admin so the administrator could do various updates before the front end re got everything and cached it HTH On Thu, 13 Jan 2005 17:03:10 -0500, Jeffry Houser <[EMAIL PROTECTED]> wrote: > Yep, SQL Server 2000. Got any juicy tid-bits of info like "well, if you > click this button, everything works great"? > > At 04:04 PM 1/13/2005, you wrote: > >Subject: Sites Under Load > >From: "Jacob" <[EMAIL PROTECTED]> > >Date: Thu, 13 Jan 2005 12:44:19 -0800 > >Thread: > >http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid=15553&forumid=5#142434 > > > >What database server? SQL 2000? > > > >-----Original Message----- > >From: Jeffry Houser [mailto:[EMAIL PROTECTED] > >Sent: Thursday, January 13, 2005 12:20 PM > >To: CF-Community > >Subject: Sites Under Load > > > > I'm working on my first site which is failing under load. I feel > >helpless. > > > > Interesting (at least to me) is that the problem appears to be w/ the > >database server, not the ColdFusion servers. However, once the DB Server > >ramps up to 100% utilization, CF starts spouting out timeout errors very > >fiercely. In the error template, we had rigged up something to cfmail the > >error. I got around 1600 email messages in the past 15 hours (before we > >commented out that code). > > > > I know there was something documented w/ CFMX and old database drivers, > >but I have been assured that our versions are up to date. Anyone know how > >can I verify? > > > > > >-- > >Jeffry Houser, Web Developer, Writer, Songwriter, Recording Engineer > >AIM: Reboog711 | Phone: 1-203-379-0773 > >-- > >My Books: <http://www.instantcoldfusion.com> > >My Recording Studio: <http://www.fcfstudios.com> > >My Energetic Acoustic Rock Band: <http://www.farcryfly.com> > >-- > >When did Reality Become TV > > -- > Jeffry Houser, Web Developer, Writer, Songwriter, Recording Engineer > AIM: Reboog711 | Phone: 1-203-379-0773 > -- > My Books: <http://www.instantcoldfusion.com> > My Recording Studio: <http://www.fcfstudios.com> > My Energetic Acoustic Rock Band: <http://www.farcryfly.com> > -- > When did Reality Become TV > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase Dreamweaver with Homesite Plus from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=54 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:142449 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
