Re: Table in Memory

2003-11-05 Thread Matt W
ble (after the first access) should be as fast as putting it on a RAM disk or whatever people might suggest. Matt - Original Message - From: <[EMAIL PROTECTED]> To: "Arnoldus Th.J. Koeleman" Cc: <[EMAIL PROTECTED]> Sent: Wednesday, November 05, 2003 11:03 AM Su

Re: Table in Memory

2003-11-05 Thread colbey
Maybe look at using a HEAP table? Load it on startup from a datasource.. On Wed, 5 Nov 2003, Arnoldus Th.J. Koeleman wrote: > > > I have a large table which I like to store into memory . > > > > > > > > Table looks like > > > > Spid_1__0 > > > > (recordname varchar(20) primary key, > > > > dat