CODEWITHSUNDEEP
c#asp.netcaching
Kelly Robins
Kelly Robins

Reputation: 7288

Asp.net - Caching vs Static Variable for storing a Dictionary

I am building a web-store with many departments and categories. They are stored in our database and accessed often.

We are using URL rewriting so almost every request within the store generates a lookup. We also need to iterate over the data frequently to generate menus for the main store and the department pages.

This information will not change often so I'm thinking that I should load the database into a dictionary to speed up the information retrieval.

I know the standard practice is to load data into the application cache, however i assume that there is some level of serialization that occurs during caching, and for a large data-structure I'm thinking the overhead would be significant.

My impulse on this is to put the dictionary in a static variable in one of the related classes. I would however like to get some input input on this. Am I right in thinking that this method would be faster? Is it horrible practice? Is there a better way that I'm missing?

I can't seem to find much information on this and I'd really appreciate any information that you can share. Thanks!

Upvotes: 21

Views: 13761

Answers (4)

MPD
MPD

Reputation: 1

IMHO, generally speaking, if you have control on updates on underlying object, you should use static storage. Otherwise, if you are dependent on a 3rd party API for data retrievals, use Caching technology.

Upvotes: 0

davewasthere
davewasthere

Reputation: 3028

memcached is your friend! (but could be overkill if you're not scaling out)

Any idea how large your dictionary would be in application cache? I'd be tempted to recommend that as a good first option.

Upvotes: 3

Pawel Krakowiak
Pawel Krakowiak

Reputation: 10090

Well, I don't think it's so much work to rewrite code to use a static field instead of application cache if there's need to do so. I'd personally use the cache first. There's no need for premature optimization, have you measured the performance? It may behave just right with the application cache object. Maybe it even works well with db queries? :)

So, my answer is - use the cache and see how it works.

Upvotes: 4

LorenVS
LorenVS

Reputation: 12857

The Application and Cache collections do not serialize the objects you pass into them, they store the actual reference. Retrieving an object from Cache will not be an expensive operation, no matter how large the object is. Always stick with the Cache objects unless you have a very good reason not to, its just good practice.

The only other thing worth mentioning is to make sure you think about multithreaded access to this collection. You're going to end up with some serious issues very quickly if you don't lock properly

Upvotes: 20

Related Questions