Re: I need 50.000 inserts / second

2002-05-31 Thread Cesar Mello - Axi
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++

Re: I need 50.000 inserts / second

2002-05-31 Thread Cesar Mello - Axi
query in mysql++ that could take 1000 or more parameters?? Please tell me the alternative you were thinking about. Best regards, Cesar - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Cesar Mello - Axi [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 9

I need 50.000 inserts / second

2002-05-30 Thread Cesar Mello - Axi
Hello, I intend to use MySQL in a data acquisition software. The actual version stores the acquired data straight in files. The sample rate can get up to 50 kHz. I would like to know if there is some way to improve MySQL insert rate. The following C++ code with mysql++ takes 5 seconds to execute

Discovering which foreign key constraint failed

2002-05-29 Thread Cesar Mello - Axi
Hello, I'm using InnoDB tables, is there a way to know which foreign key constraint was violated? Oracle gives me the constraint name in the error message, so that I can seek in the data dictionary. I'm porting an web application developed for Oracle to MySQL, so I need a solution with the