Caching a Large DataSet

[Guest]

I maintain a list of companies in my application. The first time the company table is accessed, I create a dataset and stick it in the Cache. When the company table is modified, I expire the cached item, recreate the DataSet, and stick it in the Cache again

I get excellent performance when running this on my local machine. I can tell when an aspx is accessing a cached copy of the company list since it's very fast. However, it's painfully slow on my production server.

I'm starting to wonder whether it's efficient to store a DataSet that large (1 table, 4000 rows, 5 columns) in the Cache. Should I consider another data type such as an ArrayList that would be lighter to carry around?

 

[Alvin Bruney [MVP]]

That size data is not overly large IMHO and it should not present a problem
normally. What kind of traffic are you seeing which leads to the slowdown?
If you have a large number of concurrent users, then you may feel a pinch
when the cache is accessed to service a request. Outside of that, i'd
probably start looking at some other factors for the slowness.

Alternatively, you may want to try going straight to the database as a
troubleshooting technique to pinpoint the problem. See if that helps any.
--
Regards,
Alvin Bruney [ASP.NET MVP]
Got tidbits? Get it here...
http://tinyurl.com/3he3b

I maintain a list of companies in my application. The first time the

company table is accessed, I create a dataset and stick it in the Cache.
When the company table is modified, I expire the cached item, recreate the
DataSet, and stick it in the Cache again.

I get excellent performance when running this on my local machine. I can

tell when an aspx is accessing a cached copy of the company list since it's
very fast. However, it's painfully slow on my production server.

I'm starting to wonder whether it's efficient to store a DataSet that

large (1 table, 4000 rows, 5 columns) in the Cache. Should I consider
another data type such as an ArrayList that would be lighter to carry
around?