[GitHub] [superset] hungpv29 commented on issue #15854: [Roles Page] page load is very slow

[GitBox <gi...@apache.org>]

hungpv29 commented on issue #15854:
URL: https://github.com/apache/superset/issues/15854#issuecomment-1282908516

   I have the same with the Superset 1.5.1. When go to List Roles Page, it calls `Postgres ab_view_menu select ` **44900** times
   ![image](https://user-images.githubusercontent.com/64894530/196526640-770cc7ba-3370-409a-ae80-fbe99de55728.png)
   
   Query:
   ```
   SELECT ab_view_menu.name AS ab_view_menu_name FROM ab_view_menu JOIN ab_permission_view ON ab_view_menu.id = ab_permission_view.view_menu_id JOIN ab_permission ON ab_permission.id = ab_permission_view.permission_id JOIN ab_permission_view_role ON ab_permission_view.id = ab_permission_view_role.permission_view_id JOIN ab_role ON ab_role.id = ab_permission_view_role.role_id JOIN ab_user_role ON ab_role.id = ab_user_role.role_id JOIN ab_user ON ab_user.id = ab_user_role.user_id WHERE ab_user.id = %(id_1)s AND ab_permission.name = %(name_1)s
   ```


-- 
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: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org