No, however, SQL engine has quite good disk data caching - if some data from your table is used often, sql will keep most of it in memory.
-----Original Message----- From: Justin [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 3:21 PM To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] SQL DB speed Is there a way in MS SQL server to put a table into a memory?? Thanks Justin -----Original Message----- From: Albert Popkov [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 14:53 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] SQL DB speed 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] -- ** 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]
