List:General Discussion« Previous MessageNext Message »
From:Cesar Mello - Axi Date:May 31 2002 5:54pm
Subject:Re: I need 50.000 inserts / second
View as plain text  
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.

>I might be missunderstanding You since I don't get this together...
>   You wrote:
>   The following C++ code with mysql++ takes 5 seconds to
>   execute in my Athlon 1.33 machine:
>
>   And later on:
>   I'm shocked with the performance of MySQL, a similar query
>   to compute 1 million records takes 1.17 seconds in MySQL

>So , if "similar" query makes 1 million in about a second, how
>come You have problems with "only" 50 K/s with another "similar"
>query....

The code shown INSERTs 50.000 records in the database and takes 5 seconds to
run. My comment later about the query is about
the SELECT with a GROUP BY clause, it takes 1.17 seconds to compute 1
million records.

Thank you anyway, I'll be testing Jeremy's idea when I arrive home at night.

Best regards,
Cesar


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