24.01.2014, 18:04
Something must be wrong with your mysql (either the service itself or the plugin somehow)..
I used this code and i got in the console
"took 4376 milliseconds"
And if i try with only 200 it takes just 1 millisecond !
And also..the server shouldn't be hanged while inserting the data..that's weird(atleast with r7+)
It may take a while to insert those 1000000 that i tested it with but the server isn't hanged,it works just fine.
Did you try running it from the gamemode ?
pawn Код:
main() {
g_con = mysql_connect("127.0.0.1","root","test","");
new tick = GetTickCount();
for(new i;i != 1000000;i++) {
mysql_function_query(g_con,"INSERT INTO `asd` (`1`,`2`,`3`,`4`,`5`,`6`,`7`) VALUES (1,'ddddddd',3,4,5,'aaaaaaaaaaa',7)",false,"","");
}
printf("took %d milliseconds",GetTickCount() - tick);
}
"took 4376 milliseconds"
And if i try with only 200 it takes just 1 millisecond !
And also..the server shouldn't be hanged while inserting the data..that's weird(atleast with r7+)
It may take a while to insert those 1000000 that i tested it with but the server isn't hanged,it works just fine.
Did you try running it from the gamemode ?