Hello all, I am currently creating a table per hour for some data I have. Each table has 502 fields (yeah, I know....nothing I can do about it, this is a very special situation) and about 100,000 records.
A few hours worth of data creates a 2GB table, and I don't really want to increase the size of the tables and risk something happening to *all* the data if something becomes corrupt. I'm using the MERGE feature and all has worked well so far. I am using MySQL version 3.23.52. My question is, what is the maximium number of tables I can merge together? Like I said, I create one every hour. 24 a day, 168 a week and 672 a month. I would like to keep as much data available in the merged table. I'm using a merge table so that I can query one table rather than generating a transaction of queries. Any ideas? Thanks, Kevin [EMAIL PROTECTED] --------------------------------------------------------------------- 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