Frequently Used Results
Common Query Results
- Fairly static data
- Commonly used
- Reasonable size
Place the data in an ASP+ Cache
- Use a DataSet as a convenient object to store results:
DataSet myDataSet = (DataSet)Cache["myData"];
if(null == myDataSet) {
myDataSet = doGenerateDataSet();
Cache["myData"] = myDataSet;
}
// use myDataSet…