Groups | Blog | Home
all groups > asp.net caching > april 2005 >

asp.net caching : Caching Suggestion


VK
4/29/2005 8:16:20 AM
Hello Guys,

I have an application, where 99% of the webforms
requires the user to enter some values in some textboxes
to get some data from the database. As you can guess the
data is based on the values of the textboxes. Now I would
like to cache the result returned from the database based
on the parameter. The only problem is that I dont know if
this should be done or not - because when I cache every
resultset based on the parameters, then I will end up with
a lot data in my cache.

Thanks for any suggestions.
Alvin Bruney [Microsoft MVP]
4/30/2005 12:00:00 AM
How about caching the dataset if it is not that large, then you can pull a
filter over the dataset based on the user selection to get data instead of
hitting the database.

--
Regards
Alvin Bruney
[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
available at www.lulu.com/owc
--------------------------------------------------


[quoted text, click to view]

guillaume StEtienne FR
5/3/2005 1:34:04 AM
IMO, caching will always be more efficient than querying the database
I may consume more memory, but it never consume as much CPU as a query
so it's full benefits for you.

[quoted text, click to view]
AddThis Social Bookmark Button