Performance MySQL with C-API

2001-05-08 Thread Raf Geusens
Hi, I've got a couple a questions concerning the speed of insert queries when using the C API from MySQL. I've written an application that receives data through a CORBA event channel and stores it in a MySQL database. The problem is that a lot of events are dropped. I think (I'm quite sure

C-API performance

2001-05-06 Thread Raf Geusens
Hi, I'm building a DBMs for distributed platforms using MySQL and CORBA. It's completely written but I have a question 'bout the performance, does it sound normal that I can call the next function ony 150 - 200 times a second a PIII 700mhz with 128 mb ram?? int resolvequery(char * vraag,

Benchmark

2001-05-03 Thread Raf Geusens
Hi, I wanna know how many INSERT queries my MySQL server can resolve in a second? What benckmark should I use or how should I do this? I've read something in the manual about looking for sql-bench, but it's nowhere on my pc. Is it possible that it's not installed?? Greetings, Raf

MySQL performance

2001-05-01 Thread Raf Geusens
Hi, I'm currently writing my final year thesis and i'm in need for some information on the efficiency of MySQL. If anyone knows a good site, book, paper etc ... pls let me know. I'm wondering how many request MySQL server can resolve per second and that kind of things. Thanks in advance, Raf

Performance question

2001-04-03 Thread Raf Geusens
Hi, I know I've allready posted this question but it's rather important for my final work. I'll add some extra information at the bottom. I've got a question 'bout the number of number of writes a MySQLserver can handle in a second. I've written a program which contains the following code:

Performance question

2001-04-02 Thread Raf Geusens
Hi, I've got a question 'bout the number of number of writes a MySQLserver can handle in a second. I've written a program which contains the following code: typedef struct { MYSQL * connection; char * database; } con; int