Question 2 Replies 278 Views × Close popover John Paul Raja Christu Raja (JohnPaulRaja,C) Perseus Consultant Perseus US View Profile Send Message JohnPaulRaja,C Member since 2011 261 posts Perseus Posted: October 28, 2016 Last activity: November 10, 2016 Posted: 28 Oct 2016 15:22 EDT Last activity: 10 Nov 2016 8:21 EST Closed Bulk data count values storage approach in data pages Hi, I want to get count for 500K rows and display in a screen, which one is the best way to handle. Option 1: In background get all the data in data pages, and display in the screen Option 2: In DB create separate table for count and update count table periodically. Display the values from count table ***Updated by Moderator: Marissa to update categories*** Low-Code App Development Data Integration × Close popover Facebook Twitter Linkedin Email Copy Link Copied! Moderation Team has archived post, learn more × Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 4 years ago Posted: 29 Oct 2016 11:34 EDT × Close popover Dharanitharan Ravindran (DharanitharanR) Areteans Technologies LSA, DC, CS, BA & UI Specialist Areteans Technologies AU View Profile Send Message DharanitharanR Areteans Technologies replied to JohnPaulRaja,C Dpage will have a OOTB property pxResultCount which you can use it Posted: 4 years ago Posted: 10 Nov 2016 8:21 EST × Close popover Santanu Bhattacherjee (Santanu) PEGA Manager CRM - Field Service Pegasystems Inc. IN View Profile Send Message Santanu PEGA replied to JohnPaulRaja,C Hi Even if you pull the data in background and store them all in a datapage, it might create some performance overhead.So be careful before pulling the entire lot of data. Try using Report Definition to pull the data and then use pagination to get the data on a phased manner. And for the total count, you can refer pxTotalResultCount.