Normally: Denormalise data, implement some caching, build proper indexes, buy more memory, get proper disk system, consider distributed system, etc
If you send a little bit more details about your data, how it is accessed and updated, I may be able to help better. -----Original Message----- From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 1:29 PM To: [EMAIL PROTECTED] Subject: [ cf-dev ] SQL DB speed We have a huge 11GB SQL Server database, pretty much all data is varchar, even the primary key/indexes Any tips on improving performance and speeding up searches. Russ -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
