Caching scenario suggestions

[npverni]

I have a navigation bar user control that is very expensive to create
from the database. This toolbar will only change when the user
navigates to a different section (there are three in total). What I
would like to do is cache the toolbar while the user is in a current
section, and only load it again when they change sections. Or , if I
could somehow cache all three on the initial page load and then
programatically load the desired one from the cache that would also
work. Any suggestions?

Also, the way the application is setup - the current section is not
stored in the querystring, rather the navigation controls discover the
section recursively from their parent pages.

Thanks

[Peter Bromberg [C# MVP]]

npverni,
The best "pattern" to use is to have a method that gets the data from the
database.
First, it will check the cache for DataSet, datatable, however you do it.
If the data is not present in Cache, then and only then will it make a
database call, and it will immediately cache the DataSet. Then it returns the
dataset.

You should not need to cache your actual controls, only the database action
result.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"np*****@gmail.com" wrote:

I have a navigation bar user control that is very expensive to create
from the database. This toolbar will only change when the user
navigates to a different section (there are three in total). What I
would like to do is cache the toolbar while the user is in a current
section, and only load it again when they change sections. Or , if I
could somehow cache all three on the initial page load and then
programatically load the desired one from the cache that would also
work. Any suggestions?

Also, the way the application is setup - the current section is not
stored in the querystring, rather the navigation controls discover the
section recursively from their parent pages.

Thanks