aiomysql executemany is very slow to insert

aio-libs / aiomysql

aiomysql is a library for accessing a MySQL database from the asyncio

https://aiomysql.rtfd.io

MIT License

1.72k stars 254 forks source link

aiomysql executemany is very slow to insert #984

Open RuoCJ opened 2 months ago

RuoCJ commented 2 months ago

Discussed in https://github.com/aio-libs/aiomysql/discussions/983

^{Originally posted by **RuoCJ** April 27, 2024} I used aiomysql executemany to insert over 800 pieces of data, which took over thirty seconds, but pymysql only took over two seconds。