Performance issue on admin dashboard

[vasilvestre]

Describe the proposed solution
When you have a lot of data, the dashboard can take up to 5-10 sec more depending of data. It slow the login process when you do not even need to get stats.
What could be done :

• toggle to enable/disable stats (not everyone use it)
• cache data for X minutes/hours
• move stats to another tab

Additional context
Here's a Sentry analysis of the time :

You can see the statistics do not contain code overwrite

[TheMilek]

Hi @vasilvestre!

Thank you for opening the issue,
Could you provide more information about the amount of data you are relying on?

Thanks in advance! 🍻

[vasilvestre]

Hi @vasilvestre!

Thank you for opening the issue,
Could you provide more information about the amount of data you are relying on?

Thanks in advance! 🍻

More than 10000 for this one year so 3-5k per month

[Rafikooo]

Hello @vasilvestre. We would like to inform you that we have discussed your concern and acknowledge its validity, however, it is not currently among our top priorities. It is possible that we will revisit this issue around the time of the Sylius 2.0 release 💃

[vasilvestre]

Hello @vasilvestre. We would like to inform you that we have discussed your concern and acknowledge its validity, however, it is not currently among our top priorities. It is possible that we will revisit this issue around the time of the Sylius 2.0 release 💃

I've found a solution, queries and indexes seem suboptimal. I will share the changes !

[TakesTheBiscuit]

@vasilvestre we would be interested in this also