queries complete time.
#1

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?
Reply
#2

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.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)