search

laravel / nova-issues

556 stars 34 forks source link

Dashboard and Resource Loading Very Slow #6571

Open heshammostafa123 opened 3 weeks ago

heshammostafa123 commented 3 weeks ago

Description:

When accessing the main URL of a Laravel Nova application, it may check resource.index (or similar resource actions) multiple times I have attached a sample of the log file when trying to access the main URL anyone can view it

Detailed steps to reproduce the issue on a fresh Nova installation:

laravel.log

AbdallahAli912 commented 3 weeks ago

same issue here, plz help

crynobone commented 3 weeks ago

Unable to reproduce the issue, please provide full reproducing repository based on fresh installation as suggested in the bug report template (or you can refer to https://github.com/nova-issues for example)

makowskid commented 3 days ago

Whether it's Apple M3/M4 or server with 64GB of RAM and new processor - showing Resource details or edit form takes ages. This should not be a norm:

image
makowskid commented 3 days ago

And this is my local M3 with 48 GB of RAM, mindblowingly bad performance

image
jansgescheit commented 2 days ago

I've already stumbled across it myself. You can see it even better if you run tools such as Clockwork or Debugbar and look at the database queries. Nova makes an unbelievable number of database queries, many of which probably have an n+1 problem that you don't even notice and which drag performance down to the basement

crynobone commented 2 days ago

@jansgescheit https://github.com/laravel/nova-dusk-suite/blob/8ded9c507c5ff4132f650e0c95f847440ff9c7d8/app/Providers/AppServiceProvider.php#L21-L25 Laravel Nova own test suite (integration and dusk tests) uses Model::preventLazyLoading(). If you configure everything correctly you wouldn't have n+1 issues.

@makowskid I see multiple fetch requests that isn't from a vanilla Laravel Nova installation. Unable to debug further without the reproducing repository as requested above.