asiavoices
Programmer
Hello all,
My mind is blank at the moment and can't remember if this is possible.
I've built a CF application that has a lot of stored procedures (I used to query using CFQuery but now just SP as it's more efficient) and I was wondering how I could "cache" the recordset similar to CFQUERY's "cachedwithin" parameter.
Is there a similar one for Stored Procedures? The SP is just to list about 30,000+ items (like cities) so the dataset rarely change if ever.
thanks,
Christopher
My mind is blank at the moment and can't remember if this is possible.
I've built a CF application that has a lot of stored procedures (I used to query using CFQuery but now just SP as it's more efficient) and I was wondering how I could "cache" the recordset similar to CFQUERY's "cachedwithin" parameter.
Is there a similar one for Stored Procedures? The SP is just to list about 30,000+ items (like cities) so the dataset rarely change if ever.
thanks,
Christopher