MySQL problem - 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 problem (
/showthread.php?tid=568547)
MySQL problem -
Urukhay - 23.03.2015
If send
50.000 'UPDATE' requests in the
'for' then after
15.000 requests data not stored in the database.
Why?
Plugin by BlueG
Re: MySQL problem -
Darrenr - 23.03.2015
Please rephrase the question... or maybe show us some code?
Re: MySQL problem -
Vince - 23.03.2015
And
why exactly do you need 50k updates? In any case, for such large transactions you should use, well, transactions.
PHP код:
START TRANSACTION;
UPDATE ...
UPDATE ...
UPDATE ...
COMMIT;