How SSRS handle large data when pagination is configured
when we develop report with ssrs then we can bind ssrs with sql server store procedure or c# data set. suppose sql server store procedure return 10,00,000 data and configure ssrs to show 50 data at a time in page. so my question is ssrs will fetch 10,00,000 data and store in memory but display 50 data at a time ?
if this is true then report performance will be slower and huge memory will be required and block due to large data stored. so please tell me if anyone know how ssrs handle large data.
how developer should develop ssrs when large data will be there. thanks