fix: performance issues on user and roles list

dpgaspar / Flask-AppBuilder

Simple and rapid application development framework, built on top of Flask. includes detailed security, auto CRUD generation for your models, google charts and much more. Demo (login with guest/welcome) - http://flaskappbuilder.pythonanywhere.com/

BSD 3-Clause "New" or "Revised" License

4.7k stars 1.36k forks source link

fix: performance issues on user and roles list #2209

Closed dpgaspar closed 9 months ago

dpgaspar commented 9 months ago

Description

Fixes: #2073

adds lazy joined to permission view model (fixes N+1 issue) and removes created_by and changed_by from the user list search options so we don't load all users twice on page load.

ADDITIONAL INFORMATION

[ ] Has associated issue:
[ ] Is CRUD MVC related.
[ ] Is Auth, RBAC security related.
[ ] Changes the security db schema.
[ ] Introduces new feature
[ ] Removes existing feature