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***
Posted: 2 months ago
Updated: 2 months ago
Can not use \copy in Connect-SQL, we trying using CopyManager API to create csv file
Posted: 2 months ago
Have you done any data formatting on any columns. Also, are you directly doing download from Report definition or are you doing download from a grid of displayed results.
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