MySQL slow?
#8

Something must be wrong with your mysql (either the service itself or the plugin somehow)..
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);
}
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 ?
Reply


Messages In This Thread
MySQL slow? - by PowerPC603 - 24.01.2014, 17:21
Re: MySQL slow? - by Memoryz - 24.01.2014, 17:33
Re: MySQL slow? - by PowerPC603 - 24.01.2014, 17:35
Re: MySQL slow? - by iZN - 24.01.2014, 17:38
Re: MySQL slow? - by gtaplayer1 - 24.01.2014, 17:41
Re: MySQL slow? - by Michael@Belgium - 24.01.2014, 17:44
Re: MySQL slow? - by PowerPC603 - 24.01.2014, 18:01
Re: MySQL slow? - by InfiniTy. - 24.01.2014, 18:04
Re: MySQL slow? - by PowerPC603 - 24.01.2014, 18:10
Re: MySQL slow? - by InfiniTy. - 24.01.2014, 18:32

Forum Jump:


Users browsing this thread: 1 Guest(s)