hi, I am going to use the MySQL version 3.23.47 for as our database. The issue is which table type to use. I want that the database should be (memory-resident). I have tried with the MyISAM tables which doesn't solves my purpose as in this case the data are stored in the files. I have also tried with the HEAP tables that uses a hashed index and are stored in memory. This makes them very fast, but if MySQL crashes I am loosing all data stored in that. As, I have created one table as a heap type but when I make my server down and start it again all rows created nowhere exists. So, if anybody can suggest me any process by which I can populated HEAP table(es) from a duplicate table(es) (which is on secondary storage) at the time of startup. Also, any runtime modifications in the tables will need to be updated in both the tables (one in memory and another one on disk). If any other method by which I can achieve the same.
Thanks and regards, Chetan Lavti --------------------------------------------------------------------- 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