SQLAlchemy批量插入加速

add - 逐条插入(慢)

for i in range(1000000):
    session.add(Data(n=i))
    session.commit()

bulk_save_objects - 批量插入对象（快）

session.bulk_save_objects([Data(n=i) for i in range(1000000)])
session.commit()

bulk_insert_mappings - 批量插入映射（更快）

session.bulk_insert_mappings(Data, [dict(n=i) for i in range(1000000)])

• https://docs.sqlalchemy.org/en/14/faq/performance.html#i-m-inserting-400-000-rows-with-the-orm-and-it-s-really-slow