Re: Moving memory recordsets from ADO 2 to ADO.NET

Garry,

Use DataTables to store your data and build DataViews to index and allow
databinding to display controls.

You can minimize the memory used for changing tracking by always accepting
changes. If it turns out later that your application can benefit from
change tracking, this is one complicated piece of logic you won't have to
implement.

Is your concern about a DataTable being 'weightier' more about the
additional processing power needed to maintain a DataTable or about the
memory is consumes?

Ad.


"Garry" <garryx@xxxxxxxxxxx> wrote in message
news:e5sIbCuAGHA.2040@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
> I am rewriting a medium to large financial application from VB6 to VB2005.
>
> I use memory recordsets which are build dynamically in code and are sorted
> using different sort keys embedded in the fields definitions,.
> (Collections
> will not support multiple keys.).
>
> These memory recordsets are part of the complicated logic used to display
> grids to the user using tree displays etc.
>
> In ADO.NET, I do not see a parallel object. A DataTable is much more
> complicated as it tracks changes, (I think). I have seen code examples to
> build a DataTable in code from scratch BUT this would be a much
> 'wieghtier'
> structure.
>
> As part of the redesign of the application, I want to build a User Control
> that would be based on the GridView, (or a more extensive third party
> control), with memory recordsets to store information about columns and
> rows
> so it is important to get the correct implementation in ADO.NET.
>
> Does anyone have any practical ideas????
>
>
> Garry
>


.

Relevant Pages

  • Re: Persisting a Dataset
    ... it seems like the bulk of your memory would be taken up ... > datatable contains a list of possible medical diagnosis codes. ... >> which would load the table into memory and serve all the exes. ... One of these datatables has about 5000 ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: memory leak in asp 2.0
    ... You want to tell that dataadapter in dataset is connection to database. ... Or you mean that I think that datatable is filled and ready to bind control while in reality these procedures work parallel? ... Some datatables I may fill on different pages. ... Also it would be useful to know how much specific page gets in memory or when I leave it forever, so I can release it forever. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Same question - Why use a DataTable in ASP .NET?
    ... really need read-only access to the data, some developers prefer DataTables ... closed - thereby leaking connections to the database. ... When a good deal of memory is consumed, the web server starts ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Same question - Why use a DataTable in ASP .NET?
    ... really need read-only access to the data, some developers prefer DataTables ... You can store them in Session state - if the DataTable content is relevant ... When a good deal of memory is consumed, the web server starts ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Memory leak when using Response.Write()
    ... During work with the app this number is getting bigger to ... Then memory collection is called, ... Memory Profiler says that there is a lot of strings, ... and few DataTables and DataSets, ...
    (microsoft.public.dotnet.framework.aspnet)