I guess you could save the results of every search in new tables and then on every subsequent search, see if that search has been performed and just call up the results of it rather than doing the search again. Perhaps purge the searches every day or so etc.
> -----Original Message----- > From: Snake Hollywood [mailto:[EMAIL PROTECTED] > Sent: 20 October 2003 13:29 > 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]
