tirkarthi commented on issue #31340: URL: https://github.com/apache/airflow/issues/31340#issuecomment-1832332100
@potiuk The issue exists in main branch too. We have this fixed internally and we don't use columns like created, created_by, changed_by etc. The issue is that fields like created_by is a relationship field to user model so while loading the user page all users are loaded and since created_by is a relationship to load the autocomplete options a query is done to fetch every user. When there are 100 users then 100 users to list. 100 queries for each of created, created_by, changed_by etc are done causing lot of slowness as users increase. This is an issue from flask-appbuilder and the fix we use is like a workaround to not load these fields by excluding them since they are never useful to us but other users might need these fields and that's why a PR was never created from my end. Another approach would be to change joined strategy in the models but that might cause slowness in other pages/queries. Some related issues from flask-appbuilder : https://github.com/dpgaspar/Flask-AppBuilder/issues/2073 https://github.com/dpgaspar/Flask-AppBuilder/issues/796 https://github.com/dpgaspar/Flask-AppBuilder/issues/875 -- 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]
