J
J
jtag2017-10-05 17:10:12
MySQL
jtag, 2017-10-05 17:10:12

The insert command inserts rows very slowly, how can I speed up mysql?

Approximately 100 rows per second are inserted, how can I speed up the insertion?
for (var x = 0, x < len; ++x) {
con.query("INSERT INTO `person` (`id`, ...
}

Answer the question

In order to leave comments, you need to log in

1 answer(s)
0
0xD34F, 2017-10-05
@msa6886

Why a cycle? Insert in one request.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question