Hi,
I've created an interactive grid report using a complex sql query.
This is a very fine-tuned SQL query. And loads Millions of data in few seconds on apex as well.
Though we do have parameters which reduces the row count up to 150k-300k. But when it comes to download the data, when clicked on download button, there was a delay of 10-15 mins till the download gets started.
Between this period there is no update in console or network as well.
Initially I though at click on download it may have to process data again. And thus, I've created a temporary table in which I stored the data and then get it into IG. I thought it could speed up the process since it has to get data from single table only. But no use. It still took time to start downloading process.
So, is there any way to quickly start this process?