I found a performance issue while upgrading a customers Laravel Nova installation from version 2 to 4.

Link: https://github.com/laravel/nova-issues/issues/5690

Our customer has ~60.000 records in users table. Using a filter on colum email reduces the performance a lot. In earlier version 2 opening the filter needs less than 300ms and opening the email selectbox costs less than a second. After upgrading to Nova 4 opening the filterbox needs 12 seconds and opening the email selectbox costs ~24 seconds while browser interrupts you with questions to close the tab or still waiting until process may end.

Clone this repository: https://github.com/sfroemkenjw/nova-test-performance

It contains an DDEV environment. So start the project with: ddev start

The database needs to be migrated: ddev artisan migrate

Create an admin user: ddev artisan nova:user

Launch PhpMyAdmin: ddev launch -p

Select database db and import the file: ./db-import-for-table-users.sql It just contains records since ID 2. So your admin will not be deleted. Big thanks to the service of: https://filldb.info/

Visit user resources in admin area of nova: https://nova-test-performance.ddev.site/nova/resources/user-resources

Click on the filter icon and wait...and wait...wait ;-)