Re: I need 50.000 inserts / second

[Richard Clarke]

<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