Re: I need 50.000 inserts / second

[Harald Fuchs]

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.