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 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 > baaannngggg!!!!). 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 heap tables stay in memory and not disk. The particular table > I am using doesn't change very often (once every three months or so ).Is > there a way that I can somehow keep the table from being erased on > server restarts? Is the best way perhaps copying the table to a heap > table every time the server starts up? > > - Steve > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php