mik-laj opened a new pull request #7489: [AIRFLOW-6869][WIP] Bulk fetch DAGRuns URL: https://github.com/apache/airflow/pull/7489 Another performance optimization. When a DAG file contains 200 DAGs, and each DAG contains 5 tasks, we get the following values. **Before:** Query count: 1792 Average time: 5842.346 ms **After:** Query count: 1395 Average time: 4839.020 ms **Diff:** Query count: -397 (-22%) Average time: -1003 ms (-17%) If I didn't make a mistake, when we combine the following changes: * https://github.com/apache/airflow/pull/7481 * https://github.com/apache/airflow/pull/7477 * https://github.com/apache/airflow/pull/7476 we get only... 5 queries per file instead of ....1792 Thanks for support to @evgenyshulman from Databand! --- Issue link: [AIRFLOW-6869](https://issues.apache.org/jira/browse/AIRFLOW-6869) Make sure to mark the boxes below before creating PR: [x] - [X] Description above provides context of the change - [X] Commit message/PR title starts with `[AIRFLOW-NNNN]`. AIRFLOW-NNNN = JIRA ID<sup>*</sup> - [X] Unit tests coverage for changes (not needed for documentation changes) - [X] Commits follow "[How to write a good git commit message](http://chris.beams.io/posts/git-commit/)" - [X] Relevant documentation is updated including usage instructions. - [X] I will engage committers as explained in [Contribution Workflow Example](https://github.com/apache/airflow/blob/master/CONTRIBUTING.rst#contribution-workflow-example). <sup>*</sup> For document-only changes commit message can start with `[AIRFLOW-XXXX]`. --- In case of fundamental code change, Airflow Improvement Proposal ([AIP](https://cwiki.apache.org/confluence/display/AIRFLOW/Airflow+Improvements+Proposals)) is needed. In case of a new dependency, check compliance with the [ASF 3rd Party License Policy](https://www.apache.org/legal/resolved.html#category-x). In case of backwards incompatible changes please leave a note in [UPDATING.md](https://github.com/apache/airflow/blob/master/UPDATING.md). Read the [Pull Request Guidelines](https://github.com/apache/airflow/blob/master/CONTRIBUTING.rst#pull-request-guidelines) for more information.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
