Question
3
Replies
626
Views
FPT Okinawa R&D Co., Ltd.
JP
Posted: December 8, 2020
Last activity: January 4, 2021
Last activity: 4 Jan 2021 10:48 EST
Closed
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 years ago
Updated: 2 years ago
Updated: 11 Dec 2020 2:26 EST
FPT Okinawa R&D Co., Ltd.
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: 2 years ago
Updated: 2 years ago
Updated: 14 Dec 2020 5:36 EST
FPT Okinawa R&D Co., Ltd.
JP
Can not use \copy in Connect-SQL, we trying using CopyManager API to create csv file
Posted: 2 years ago
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.