Re: I need 50.000 inserts / second

[Tõnu Samuel]

On Fri, 2002-05-31 at 20:54, Cesar Mello - Axi wrote:
> Hello,
> 
> >You could maybe buffer the data in Your application
> >and then run inserts later... like this.
> 
> This is not a solution for me as the data acquisition can take hours without
> any break.

Whatever you do, with any SQL you get stuck behind speed of parser. More
commands means more waiting. Making one INSERT for two records instead
of two INSERTs can speed up your stuff twice easily.

This is general problem of SQL.

  Tõnu