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

From: Lateralus [MCAD] (dnorm252_at_yahoo.com)
Date: 09/08/04 

Date: Wed, 8 Sep 2004 14:55:52 -0500

I think you may want to take another approach. Are there any fields you can
filter on? For instance you may have a foreign key to a lookup type table. I
would suggest making some sort of a "search" type of screen and filter your
records that way. Just dynamically build a SQL statement using the search
criteria for your where clause, that will help slim down your list. If your
data is not normalized this may be a bit difficult. You can page your
results with a DataGrid in ASP.Net, but I don't think you can with winforms.

HTH 

-- 
Lateralus [MCAD]
"VMI" <vonchi_m@yahoo.com> wrote in message 
news:Oh8dnzdlEHA.3392@TK2MSFTNGP15.phx.gbl...
> 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 ... 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?
    ... >>> 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: inserting Adobe Illustrator graphics, more experience
    ... Word's "picture editing" tools, they can work only with bitmaps. ... The 'shapes' group are all very similar to CGM (Computer Graphics Metafile) ... as a group, it can have a name, a hyperlink, display ... the import filter, which says "Is this something like CGM?" ...
    (microsoft.public.mac.office.word)
  • Re: Drag from SP2 window to desktop?
    ... > display the same help text as originally displayed by the javascript ... Embedded within the HTML will be lines like this: ... > The idea is that if the user wants to perform a "filter" operation on one ... they can drag and drop the filter icon (which is surrounded ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: Search function
    ... effect the change in display. ... Dave Hargis, Microsoft Access MVP ... "Bill" wrote: ... simply set the filter and required. ...
    (microsoft.public.access.formscoding)