other table that stores data differently than ADO.Net datatable?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: VMI (vonchi_m_at_yahoo.com)
Date: 09/08/04 

Date: Wed, 8 Sep 2004 15:00:05 -0400

We have this huge application that's based on storing tons of data on a
dataTable. The only problem we're having is that storing LOTS of data (1
million records) into a datatable will slow down the system since all this
data will be stored in memory. The performance is really affected with this.
Since we don't really want to redesign everything based on this datatable,
are there any companies that offer a product similar to the datatable that
stores lots of data in a more efficient way? Basically, we load all this
data (it's a one-shot process) into the datatable and work with that. We
don't want to change any of that; we just want something similar to the
datatable that stores a better way. Also, the windows datagrid should be
able to bind to this new table without many problems.

Thanks.

Relevant Pages

  • Re: other table that stores data differently than ADO.Net datatable?
    ... query the database everytime the user does a scroll ... will display the next N records once the user has reached the last visible ... > We have this huge application that's based on storing tons of data on a ... > datatable that stores a better way. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: other table that stores data differently than ADO.Net datatable?
    ... are facing performance hits due to the massive amount of memory taken up. ... > We have this huge application that's based on storing tons of data on a ... > datatable that stores a better way. ...
    (microsoft.public.dotnet.languages.csharp)