Question
3
Replies
114
Views
Fpt Software Joint-Stock Company
Fpt Software Joint-Stock Company
JP
Posted: December 8, 2020
Last activity: January 4, 2021
Last activity: 4 Jan 2021 10:48 EST
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: 10 months ago
Updated: 10 months ago
Updated: 11 Dec 2020 2:26 EST
Fpt Software Joint-Stock Company
Fpt Software Joint-Stock Company
JP
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
Posted: 10 months ago
Updated: 10 months ago
Updated: 14 Dec 2020 5:36 EST
Fpt Software Joint-Stock Company
Fpt Software Joint-Stock Company
JP
Can not use \copy in Connect-SQL, we trying using CopyManager API to create csv file
Posted: 9 months ago
Aaseya IT Services Pvt LTD
Aaseya IT Services Pvt LTD
IN
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.