You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@airflow.apache.org by "Kamil Bregula (Jira)" <ji...@apache.org> on 2020/03/01 10:09:00 UTC

[jira] [Created] (AIRFLOW-6963) Use low-level API for bulk insert

Kamil Bregula created AIRFLOW-6963:
--------------------------------------

             Summary: Use low-level API for bulk insert
                 Key: AIRFLOW-6963
                 URL: https://issues.apache.org/jira/browse/AIRFLOW-6963
             Project: Apache Airflow
          Issue Type: Improvement
          Components: scheduler
    Affects Versions: 1.10.9
            Reporter: Kamil Bregula


Hello,
When we add a very large number of records to the database, we should use a different API.

bulk_save_objects() or bulk_insert_mappings() provide much more performance.

More information:

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

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)