Re: heap tables keep on disappearing!

2003-03-06 Thread Paul DuBois
At 11:41 -0800 3/6/03, Steve Quezadas wrote: I have a mysql table that I refer to a lot and needs to be quick. I set it as a HEAP table because of the speed (and HEAP tales ARE fast. zip baaannn). Anyway, whenever I restart the server the contents of the heap tables disappear! What the h

Re: heap tables keep on disappearing!

2003-03-06 Thread Alec . Cawley
> Sent: Thursday, March 06, 2003 7:41 PM Subject: heap tables keep on disappearing! > I have a mysql table that I refer to a lot and needs to be quick. I set > it as a HEAP table because of the speed (and HEAP tales ARE fast. zip > baaannn). Anyway, whenever I restart the serv

Re: heap tables keep on disappearing!

2003-03-06 Thread Jerry
Store it in another table and have a start up script that creates a heap once the server is started ? Jerry - Original Message - From: "Steve Quezadas" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, March 06, 2003 7:41 PM Subject: heap tables keep on di

heap tables keep on disappearing!

2003-03-06 Thread Steve Quezadas
I have a mysql table that I refer to a lot and needs to be quick. I set it as a HEAP table because of the speed (and HEAP tales ARE fast. zip baaannn). Anyway, whenever I restart the server the contents of the heap tables disappear! What the hell? But I read the manual and it seems that