SA-MP Forums Archive
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