queries complete time. - 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: queries complete time. (/showthread.php?tid=621460)

---

queries complete time. - MerryDeer - 11.11.2016

Hi,

I send for testing about 10.000 mysql queries (insert) i too make test command for mysql_unprocessed_queries(), to know how much queries is not completed. Ok when i send 10.000 queries, i start to write command look how much queries are not completed, interval was about second and queries was completed about 50-80. So this is limit for mysql?

---

Re: queries complete time. - Vince - 11.11.2016

A single simple insert query usually takes about 5 to 10 milliseconds. Bulk inserts (i.e. more than a couple rows at a time) are usually performed with prepared queries or transactions.

---