<snip> > > > INSERT INTO my_table VALUES (foo, foo), (bar, bar), (z, z)... > <snip>
>From my own experience, by using this method, that is doing one insert per 200 or more rows I can increase the insert speed from between 5x - 10x. A couple more performance improvements where made as well so that value isn't a strict reflection, but it certainly help enormously. You can easily test this by dumping a large number of rows using mysqldump and mysqldump -e and then comparing the re-insert speeds. Ric --------------------------------------------------------------------- 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
