List:General Discussion« Previous MessageNext Message »
From:Harald Fuchs Date:May 31 2002 12:15pm
Subject:Re: I need 50.000 inserts / second
View as plain text  
In article <20020530220402.A20427@stripped>,
Jeremy Zawodny <jzawodn@stripped> writes:

>> As you can see there are only two fields: a double timestamp and a
>> double value. In the real application there are some more double
>> values. I need to decrease this time to less than 1 second. Is there
>> any kind of buffered inserts or maybe a way that I could pass a
>> matrix?

> You can boost the performance by inserting several records at the same
> time in one querey using MySQL's extended insert syntax:

>   INSERT INTO my_table VALUES (foo, foo), (bar, bar), (z, z)...

> Try batching them in groups of 100 or even 1000 to see how it
> performs.

Moreover, drop or disable indices on the table in question before
doing mass INSERTs.  You could also mess with INSERT DELAYED.
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