loynoir/benchmark-python-orm

peewee vs sqlalchemy vs raw sqlite

Python: 3.10.2 (main, Jan 18 2022, 19:45:14) [GCC 10.2.1 20210110]
sqlalchemy v1.4.31 (future=True)
peewee v3.14.8
peewee atomic:
          Total time for 100000 records 13.342 secs
SQLA ORM:
          Total time for 100000 records 8.067 secs
SQLA ORM pk given:
          Total time for 100000 records 5.068 secs
SQLA ORM bulk_save_objects:
          Total time for 100000 records 2.153 secs
SQLA ORM bulk_save_objects, return_defaults:
          Total time for 100000 records 6.125 secs
SQLA ORM bulk_insert_mappings:
          Total time for 100000 records 0.640 secs
SQLA ORM bulk_insert_mappings, return_defaults:
          Total time for 100000 records 4.270 secs
SQLA Core:
          Total time for 100000 records 0.403 secs
sqlite3:
          Total time for 100000 records 0.201 secs