When you need to test perfermance of big size data.
How to insert 100000000 test data in a fast way.
Write a python script to do this:
For perfermance, create a mysql session will need some time, so if one time insert more data will less the time.
1 | import mysql.connector |
Btw, you can customize the data you want to insert.