Question2Replies271Views JohnPaulRaja,C Member since 2011 247 posts Cognizant Posted: October 28, 2016Last activity: November 10, 2016 Closed Bulk data count values storage approach in data pagesHi, 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 screenOption 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 popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post 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 agoDharanitharanR Areteans Technologies replied to JohnPaulRaja,CDpage will have a OOTB property pxResultCount which you can use it Posted: 4 years agoSantanu PEGA replied to JohnPaulRaja,CHi 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.