List:General Discussion« Previous MessageNext Message »
From:Richard Clarke Date:June 1 2002 7:09pm
Subject:Re: I need 50.000 inserts / second
View as plain text  
<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





Thread
I need 50.000 inserts / secondCesar Mello - Axi31 May
  • Re: I need 50.000 inserts / secondJeremy Zawodny31 May
  • Re: I need 50.000 inserts / secondSteve Edberg31 May
  • Re: I need 50.000 inserts / secondHarald Fuchs31 May
  • Re: I need 50.000 inserts / secondMark31 May
    • Re: I need 50.000 inserts / secondBenjamin Pflugmann31 May
    • Re: I need 50.000 inserts / secondDan Nelson31 May
      • Re: I need 50.000 inserts / secondJeremy Zawodny1 Jun
  • Re: I need 50.000 inserts / secondMark31 May
  • Re: I need 50.000 inserts / secondCesar Mello - Axi31 May
    • Re: I need 50.000 inserts / secondmos2 Jun
  • Re: I need 50.000 inserts / secondRichard Clarke2 Jun
RE: I need 50.000 inserts / seconddomi31 May
  • Re: I need 50.000 inserts / secondCesar Mello - Axi31 May
    • Re: I need 50.000 inserts / secondT├Ánu Samuel31 May
    • Re: I need 50.000 inserts / secondBrent Baisley31 May