Hi, HEAP tables don't currently support TEXT/BLOB columns.
My answer about storing the table "in memory": don't bother. If you have enough free RAM to use to put the table "in memory," the OS will already do it for you after it's accessed. Thus, reading the table (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 Subject: Re: Table in Memory > 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, > > > > > > > > data blob not null > > > > > > > > ) > > > > > > > > > > > > > > > > > > > > > > > > what is the best way todo this in mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
