Frappe Insights – Query Loading Extremely Slow and Timing Out

Hello,

I am experiencing a major loading issue in Frappe Insights. The queries are taking a very long time to fetch data, and eventually they time out. I have already enabled the Data Store option in both Query Builders, but the issue still persists.

The table contains approximately 2.5 lakh (250,000) rows, and while loading the result set, Insights shows a loading spinner for a long time and then displays a timeout error.

I have attached a screenshot for reference.
Kindly look into this issue and advise how it can be resolved.