Caching SQL Results for Fast Report Export
Hi Team,
We are currently using fast report in .NET 3.1.
The situation is when we are generating a report it generates SQL query and fetched records and rendered in application as preview. Again while trying to export the report as pdf or excel ,the same query is executing from the first step and generating the same result and finally its exporting.
Generally Caching technique is preferred for small memory consuming data, Are any other technique can be used to overcome the above situation?
It would be great help if any thoughts or hits received
Comments