List:General Discussion« Previous MessageNext Message »
From:Tõnu Samuel Date:May 31 2002 1:51pm
Subject:Re: I need 50.000 inserts / second
View as plain text  
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

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