Dashboard in the browser is very slow about pulse HOT 15 CLOSED

I'm having trouble replicating this one.

I recorded and let it run for just over 15 seconds to capture a few updates.

If I resize the window constantly while recording then I can get the rendering and painting numbers up, but I assume that's to be expected as I'm forcing it to constantly re-render for the duration of the recording.

from pulse.

Chrome Version 120.0.6099.62 (Official Build) (arm64)
Apple M2 Max

from pulse.

<livewire:pulse.slow-queries cols="8" />
Appears to be the one that is currently making the layout slow.

select count(*) from pulse_aggregates where type = "slow_query"
1590

from pulse.

Wonder if this is related to the SQL syntax highlighting.

@incon do you have a bunch of queries in the slow queries table? If you remove some does it improve in speed? If you only have one is it better, and if have none is it fast again?

from pulse.

Assuming this is an issue with the number of DOM nodes with specific styling being created by the syntax highlighting - I'm adding a option to disable syntax highlighting over here: #172

from pulse.

#172 is released now. Feel free to re-open if there are still issues 👍

from pulse.

While much improved with PULSE_SLOW_QUERIES_HIGHLIGHTING=false it's still slow.

from pulse.

@incon do you have a bunch of queries in the slow queries table? If you remove some does it improve in speed? If you only have one is it better, and if have none is it fast again?

from pulse.

@timacdonald Removing them makes the dashboard fast again.

from pulse.

https://github.com/laravel/pulse/blob/9eda727da25be60c838fb604daced2073c1607fd/config/pulse.php#L191C1-L200C11

@incon did you also update the config/pulse.php containing the new options? Trying to exclude any gotcha.

from pulse.

#227 While in local development with a low threshold. I ended up with lots of telescope entries in the slow queries table. This made the dashboard very slow with over 1000 slow queries.

It would nice if slow queries could be aggregated based on the SQL prepare statement.

from pulse.

@incon thanks for the PR. Just to confirm, are you saying that the Telescope queries are the issue here?

from pulse.

In this case yes, but the issue is displaying the 1000 slow quires all at once if you have that many slow queries.

from pulse.

@incon that is interesting. It should have limited the slow queries to only show 100 at most on the dashboard.

We will have to take a look at that.

from pulse.

I'm not able to reproduce this on a fully filled dashboard, i.e., where all tables have the max of 100 items each.

We might close this and if we hear others are having issues we can dig in. Obviously happy for a fix if we can come up with one.

from pulse.