Question

3
Replies
74
Views
Close popover
Lanh NguyenTrung (LanhNT)
Fpt Software Joint-Stock Company

Fpt Software Joint-Stock Company
JP
LanhNT Member since 2018 8 posts
Fpt Software Joint-Stock Company
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***
Pega Platform 8.4.2 Reporting Data Integration Technology Services System Architect