Click here to Skip to main content
15,886,919 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am developing a report for my application. The required data for report comes from execution of stored procedure. I will format the records and show in my application. Execution of stored procedure needs about 10 parameters which comes from Dropdown list of Application (which basically means data in reports will change as parameter changes). It will also have significant impact on speed of application.

I have decided to use caching to deal with speed issues. Since I have not used caching before, based on my research on caching, I am confused on how to use caching efficiently. Based on my research, caching holds the data for certain specified interval. This could have worked if my report had same parameter injected all the times. However, this is not the case. How can I use caching technique on reports that varies with change in parameters??? What is the best method to speed up the application ???

What I have tried:

Researched on caching technique but found out that it can only hold report with same parameter.
Posted
Updated 15-Dec-16 1:41am

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900