I got into trouble the other day trying to delete gobs of rows. Actually I was selecting 90% of the rows from table1 and inserting them into a table2, then deleting from table1. It was way too slow! So I stopped all activity (inserts) from table1 and flipped table1 with table2 using rename statements. Then started up the inserts! Worked great. How can I do this with out stoping inserts? Can I lock the table1, rename table1 to table2, then create a new table1 and release all locks? --------------------------------------------------------------------- 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
