Question
3
Replies
74
Views
Posted: December 8, 2020
Last activity: January 4, 2021
Download large data to excel file (max 500,000 records)
We have a requirement to download a large data from Postgres (max 500,000 records) to excel file. We using Export to Excel on Report Definition but performance too high, CPU 25% on AP server and 20% on DB server and it take 30min for one request. Any one can suggest me another way to improve the performance
Thanks and regards,
LanhNT7
***Edited by Moderator: Pooja Gadige to add platform capability tag***
We use Connect-SQL to execute COPY SQL but don't know how to set export path to download, anyone can help me ?
Thanks and regards,
LanhNT7