In agreement with everything said by others. There's my five cents.
In order to effectively wrestle with traffic overload the following are well
tested approaches:
1. Use Static (HTML) frontpage, instead of Dynamically generated
2. Cache frequent SQL query results into TXT files, rather than quering
the DB Server directly
3. Populate Indexes for Frequently used Data Tables
In case of a complete disaster there's always an option to switch over
to HTML driven site, Each static page would have to be generated using
Product Info from Database on the schedule. As often as your hardware can
handle it. Only checkout process will remain dynamic at this time.
Throwing more hardware for an application to chew will only provide a
temporary relief, or none at all. It is likely a Code/Query/Index related
issue.
Good luck,
Andre Rekhtine
IS Consultant, MCSE
Moveable Online Inc.
[EMAIL PROTECTED]
----- Original Message -----
From: Ian Daniel
To: [email protected]
Sent: Saturday, October 14, 2006 2:20 AM
Subject: RE: Witango-Talk: Urgent Question re Thread Count -- Quick Answers,
Please ..
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
