[MySQL] UPDATE takes too long ... - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: [MySQL] UPDATE takes too long ... (/showthread.php?tid=314517)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: [MySQL] UPDATE takes too long ... (/showthread.php?tid=314517)
[MySQL] UPDATE takes too long ... - Momo5000 - 30.01.2012
Hey there, i have a problem with my mysql query,
im using this query here:
Код:
new start = GetTickCount();
mysql_query("UPDATE `Accounts` SET `Online` = '0' WHERE `Username` = 'Momo'");
printf("Time used: %ims", GetTickCount() - start);
is this normal? could you test it how long this code needs on your computer?
im using XAMPP with MySQL.
PC: i7 2600K, 16GB DDR3
Re: [MySQL] UPDATE takes too long ... - jamesbond007 - 30.01.2012
****** says 40 ms = 0.04 seconds
thats pretty fast imo
Re: [MySQL] UPDATE takes too long ... - T0pAz - 30.01.2012
40ms slow? Are you light?
AW: [MySQL] UPDATE takes too long ... - Momo5000 - 30.01.2012
so is this okay?
Re: [MySQL] UPDATE takes too long ... - jamesbond007 - 30.01.2012
yep... no worries