Caching a Large DataSet

From: George Durzi (anonymous_at_discussions.microsoft.com)
Date: 03/01/04 

Date: Sun, 29 Feb 2004 16:21:05 -0800

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?

Relevant Pages

  • Re: What is Needed to Get an ASP.NET Page to Work?
    ... .aspx page on our production server that I compiled in Visual Studio. ... production server so I had a backup copy of the original files in case ... application into a different test directory on my localhost. ...
    (microsoft.public.dotnet.framework.aspnet)
  • What is Needed to Get an ASP.NET Page to Work?
    ... but somehow managed to install a perfectly working ... ..aspx page on our production server that I compiled in Visual Studio. ... application into a different test directory on my localhost. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: What is Needed to Get an ASP.NET Page to Work?
    ... Gaurav Vaish wrote: ... .aspx page on our production server that I compiled in Visual Studio. ... application into a different test directory on my localhost. ...
    (microsoft.public.dotnet.framework.aspnet)
  • copy paste deployment
    ... I'm running an asp.net application on my local machine and on a ... THe problem is when I copy the aspx & aspx.cs file to the web server I ... don't have the chance to do that since I don;t have vs installed. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Global Assembly Cache
    ... Microsoft MVP ... "George Durzi" wrote in message ... Went to my production server and realized that I ... > Can I simply copy the .snk file from my local machine? ...
    (microsoft.public.dotnet.framework.aspnet)