aiomysql executemany is very slow to insert

[RuoCJ]

I used aiomysql executemany to insert over 800 pieces of data, which took over thirty seconds, but pymysql only took over two seconds。

[dodysw2]

Hint, check your insert query if it matches this regex at this line:

aiomysql/aiomysql/cursors.py

Line 19 in 83aa96e

RE_INSERT_VALUES = re.compile(

There's a logic that if the query doesn't match, it will turn executemany into individual insert queries instead of a batched one.