mikaelfr edited a comment on pull request #9204: URL: https://github.com/apache/airflow/pull/9204#issuecomment-642604377
> > > Have you checked how this change affects queries count? I'm afraid that so many related objects can cause performance degradation. > > https://github.com/apache/airflow/blob/e0c0e0190b3c0d611da519236d090495f764ce47/tests/models/test_dag.py#L662 No, I haven't tested query counts for task instances. I can potentially see some performance degradation when you have tasks that run frequently with a few tags each. One thing I could do is to remove foreign keys from task_tag table and just manually join task instances and task tags on task_id and dag_id. This should keep task tags table lighter at least. What do you think? ---------------------------------------------------------------- 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]
