At 03:04 AM 1/14/2005, you wrote: >Is the load just really huge, or do you suspect a self-inflicted injury? >See Mike's comments about well-indexed tables, etc.
They are sending out daily emails to the "client base". Over the course of 2 weeks, they are emailing about 12,000 people a day. The first few hours after that email goes out, the site is slammed and we get tons of errors and timeouts. After that initial jump, it tickers off and everything works relatively fine. Thanks all for your responses. I really wasn't looking for answers, just to complain. In all truth, the client hasn't been leaning on me to address this issue. But, To answer a few questions: Are the DB Tables well-indexed? I have no idea. I've never done anything specific to optimize the database. They had their on-staff DB expert watching the database "live" yesterday during the problems. I imagine he may have made some modifications based on what he was seeing, but no guarantees. Version 4 of their product was a complete rewrite of the app from scratch. About a year ago, coming up to the release of "Version 4" of their product, they were having trouble importing legacy data into the new system. Apparently the faction who said "if we remove all these pesky DB relationships, it'll work" won. So, the DB has no defined relationships, and in many cases no Primary Keys in the tables. I'm not up on SQL Server performance tuning tips. I opened up a few of the "more important" tables, such as the user table. No keys, no indexes. I'm sure that is (or was) part of the problem. Hopefully the SQL Server guy added some of that stuff to production (I only looked at Dev) On a different note, CF Debugging is turned on, but limited via IP. Is the debugging info still generated on every request? I remember that being the case in CF5, but I'm not sure if that changed in CFMX or not. -- 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:142497 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=89.70.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
