Querying Millions of Records

Question

Hi Experts, 
 
 Need suggestions on below question: 
 1: How to export data from DB to Excel if no of records are in million 
 2: Which type of record to used if data is in million and how.( Entity baked/Expression Baked and how to keep them memory Efficient) 
 3: How to optimize Views 
 
 Thanks, 
 Gaurav Singh

Mike Schmitt · Answer

The Export Data Store Entity to Excel smart service automatically handles paging to allow for very large data sets to be exported without hitting query memory limits. However with millions of records, I'm unclear as to whether an Excel file will even work when you attempt to open it.