Hi, I want to insert 5M text into a table, and I execute the statement 10 times at one time.
And then it execute very slowly, it use 27 minutes to insert all the 10 sql statements. Can anyone tell me how to optimize it, let it faster ? And Is the mysql locked on table or on the row? mysql version: 3.23.42. os : linux 2.2.16 Thanks in advance --------------------------------------------------------------------- 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
