I have requirement to fetch data from DB and move it to Native Excel file using DSP. Where DSP page will have simple download button and end-user allowed to download file. data size will be about 20 MB. I tried below steps:
- Read data from DB using Adapter.
- Push data to IS Cache. ( for faster fetch)
- call fetch data service in DSP like table.
- Call JS to move Table data to Excel file.
- Call another JS to hide table content and show only download button to download excel file.
Code is working fine and able to download file but issue is it taking move than 4 min time to perform all above options.
Can some one suggest more suitable options here to reduce download time.