tirkarthi commented on issue #60265: URL: https://github.com/apache/airflow/issues/60265#issuecomment-3724879475
> Looking at your PR, are you sure the query is what takes time and not the session creation? I am wondering if we should not cache or find a way to reuse a connection but do the query anyway I don't think the session creation is causing the issue here. After `GetUserDep` there is also check for the dag to belong to the teams which also uses a new session. I tried the patch to return from cache yet create a session every time for validation and it was still faster. The issue seems to be from the complex join query for roles, permissions. -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
