Report taking longer time to refresh
I have a report which is taking a bit longer time to refresh. I have optimized the query at MYSQL level (query refreshes in 10 sec) but when I run the same report on YF, it takes round about 25 seconds.
The report returns almost 2 million records in total. I thought of doing cached filters but then it has too many filter values.
Could you please assist me on different ways where I can optimize the report at YF level.