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, MYSQL_RES& toReturn, int& affected, int
control) {
MYSQL_RES * result;
MYSQL_ROW row;
int state,counter;
char * query;
char * db;
MYSQL * connect;
int * temporal;
connect = standardcon.connection;
db = standardcon.database;
state = mysql_real_query(connect, vraag, 1024);
if (state != 0) {
printf(mysql_error(connect));
return 1;
}
if((strncmp(vraag,"SEL",3)==0)||(strncmp(vraag,"SHO",3)==0)
||(strncmp(vraag,"DES",3)==0))
{
result = mysql_store_result(connect);
affected = mysql_num_rows(result);
toReturn = *result;
}
else
affected = 0;
return 0;
}
If it's not normal: how should I make my program better? I'm also still
looking for a good and easy benchmark to test the MySQL-server??
Thanks,
Raf
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
