How to Perform Bulk Inserts With SQLAlchemy Efficiently in Python | by Lynn Kwong | Sep, 2022
Learn different ways to insert large numbers of records into the database efficiently in PythonImage by PublicDomainPictures in PixabayIt’s very convenient to use SQLAlchemy to interact with relational databases with plain SQL queries or object-relational mappers (ORM). However, when it comes to bulk inserts, namely, inserting a large number of records into a table, we may often have performance issues. In this post, we will introduce different ways for bulk inserts and compare their performances through a hands-on…