Frappe Insights loading time is a lot. Is this common? how to overcome this speed issue. In other visualization tools is superfast(may be they could be caching it on the client server end, if so can we do it in Frappe Insights)

[Ashwinnontechie]

quick context,

1. I am running Frappe CRM on my own servers and have connected the DB to Frappe Insights.
2. Major operations on insights is query building from my tables and visualizing via charts in dashboards.

https://drive.google.com/file/d/1tSPpeGyyM01RGEb2y_c-qqeCdTdJyrGU/view?usp=drive_link -> for video reference

[Ashwinnontechie]

Hi, were you able to validate this issue. Thanks. @shahzeelahmed

[ankulpolara]

same issue

[ankulpolara]

as i add more and more dashoard in insights it make my frappe insights to more weighty and now whole site freezing

[ankulpolara]

i think need to apply caching machanism for this issue

so if multiple user hit request for report so one cached query can serve to all and load on database can be handle effectively

[Ashwinnontechie]

Hi Any update on this

[nextchamp-saqib]

If each doctype the dashboard is using has less than 10 lakh rows then enable data store for each of your queries, you'll see major improvements. However, the dashboard data will be updated once a day

The slowness has nothing to do with Insights, it is dependent on how long each query takes to execute and your database server configuration.

Also, let me know if you have enabled "user permissions" in the insights settings

[nextchamp-saqib]

i think need to apply caching machanism for this issue

so if multiple user hit request for report so one cached query can serve to all and load on database can be handle effectively

You should probably create a replica for your production database and connect that to insights. We do the same.