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

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

Date: Wed, 8 Sep 2004 15:53:43 -0400

Thanks for your replies.
We were initially working with 10,000-15,000 records and we never imagined
that these records would reach 1 million, so it's really something we didn't
think through very well (aka a design flaw).
We've already migrated the data to database but we don't exactly know how to
query the database everytime the user does a scroll (or page up/page down)
in the grid. What event should we capture in order to query the DB again and
fill the table? Also, I assume we need to create a Select statement that
will display the next N records once the user has reached the last visible
record in the grid/datatable (in pseudocode: "Select the next N records from
table following the last record displayed"). That's what we haven't been
able to figure out.

Any help is appreciated.

"VMI" <vonchi_m@yahoo.com> wrote in message
news:uMKEpVdlEHA.2680@TK2MSFTNGP15.phx.gbl...
> 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 (or page up/page ... >>> will display the next N records once the user has reached the last ... >>>> We have this huge application that's based on storing tons of data on ... >>>> datatable that stores a better way. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: other table that stores data differently than ADO.Net datatable?
    ... would suggest making some sort of a "search" type of screen and filter your ... > 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)
  • Count based on criteria
    ... I have the following query with the following: ... OnHand (count stores>2) ... Stores should not be displayed and I don't want to display values>2 or>3 ...
    (microsoft.public.access.queries)
  • RE: Count based on criteria
    ... I'm trying to create another query from Query 1 ... OnHand (count stores>2) ... Stores should not be displayed and I don't want to display values>2 or>3 ...
    (microsoft.public.access.queries)
  • Calendar Query Changes Problem!!!!
    ... I have an events calendar, ... It stores the Start Date, ... there is a Query that gets its information from the same ... are found it will display that event to the user!!! ...
    (microsoft.public.access.queries)