Hey,
I've got a query that, when executed, returns about 20 rows of data.
Since this information doesn't really change that often, I'm looking for the best way to cache the resultset.
I figure that I can store the resultset in a session variable and if it's defined to NOT run the query again but, that seems inefficient since the query would still be ran for every user/session and have the exact same data.
Is there some sort of application level that I can store this resultset at so that all users/sessions can share it and I only have to define it once?
With that said, my next question would be what is the best way to requery after 30 minutes?
Any help would be greatly appreciated!
Thanks again!
-jason
I've got a query that, when executed, returns about 20 rows of data.
Since this information doesn't really change that often, I'm looking for the best way to cache the resultset.
I figure that I can store the resultset in a session variable and if it's defined to NOT run the query again but, that seems inefficient since the query would still be ran for every user/session and have the exact same data.
Is there some sort of application level that I can store this resultset at so that all users/sessions can share it and I only have to define it once?
With that said, my next question would be what is the best way to requery after 30 minutes?
Any help would be greatly appreciated!
Thanks again!
-jason