Postgresql Sqlalchemy Commit Takes A Lot Of Time

When I'm trying to commit changes into table it takes a lot of time (about 300 seconds per each 1000 rows). Model class: class Quotes(base): __tablename__ = 'quotes' id

Solution 1:

To increase performance you can use bulk_save_method, it looks the fastest.

You can check performance http://docs.sqlalchemy.org/en/latest/faq/performance.html#i-m-inserting-400-000-rows-with-the-orm-and-it-s-really-slow