Slow? It seems to only insert about 400 rows per second. about mysql-random-data-generator HOT 5 OPEN

I was able to speed this up, and I'd be happy to share back the modifications if you like. But first, would you be willing to put up a clear license, preferably something like MIT: https://choosealicense.com/licenses/mit/#suggest-this-license

Cheers!

from mysql-random-data-generator.

Greetings Clinton,

I had plans & ideas to work on performance of the procedure trying out with delayed / bulk inserts. I'm fairly interested to know your changes leading improvements. Please share the fork/pull request. I added the MIT License.

Regards.

from mysql-random-data-generator.

I'd like to help this issue .
I think ,if someone need lots of rows , it's more efficiently inert 1000 rows in one loop instead of insert one by one

from mysql-random-data-generator.

With encouragement from @kartist I have updated the script. Please review again.

from mysql-random-data-generator.

@kedarvj

MariaDB [db]> call populate('db', 'table', 1000000, 'N');
+---------------------+
| Developed by        |
+---------------------+
| Kedar Vaijanapurkar |
+---------------------+
1 row in set (1 hour 34 min 8.535 sec)

Query OK, 1001999 rows affected (1 hour 34 min 8.539 sec)

from mysql-random-data-generator.