I am working on a asp.net application to do searches on a database with 200000 records. is it a good idea to cache search results preformed on a large database like that even though results returned are small. I am not sure if caching is needed here or not
even through I am not allowing all records to be returned. Ideally I would like to cache it once a search has been performed on some criteria. Then if user performs search on the same criteria, I dont want to perform another search but get the results from
the cache.
We’re doing something similar within an ASP.NET client application and the Web Service it consumes. In terms of achieving better performance and scalability caching is a valid option. You’ll need to figure out what impact state staleness (difference between
the database state and the actual version of the cached state) has on your process. I’d advise you to read the Caching Architecture Guide for .NET Framework Applications (http://www.microsoft.com/downloads/details.aspx?FamilyId=80134FD6-2CD4-4B7E-9CE6-90EE1E28E751&displaylang=en)
None
0 Points
10 Posts
Caching search results from database
Jan 25, 2005 02:55 PM|leotore|LINK
None
0 Points
9 Posts
Re: Caching search results from database
Mar 16, 2005 01:51 PM|Paul Gielens|LINK