Problem with loading the data in Datatables

Millions?  I would stop there, DataSetDataTables is not
designed to handle
this.


  -----Original Message-----
  From: Reddy G [mailto:reddy4allgmail.com]
  Sent: Thursday, December 07, 2006 2:57 PM
  To: DOTNET-WINFORMSDISCUSS.DEVELOP.COM; PStevensMULTICHOICE.CO.ZA;
pburrowsSTROMBERG.COM; gregCDS-AM.NET; ahmeda86hotmail.com;
ilyatumonline.microsoft.com; C.Meister-Chispeed.ch
  Subject: Problem with loading the data in Datatables


  Hi -

  I have a problem with loading the data in Datatables. I am
using vs.net
2003 environment. I have 10 Tables in my database. I am
loading 10 tables in
one dataset and creating relations for those Tables. Out of
10 tables one
table have millions of records and takes so much time to
load the data. Is
there any possiblity to load this data quickly or create a
thread which will
load this data in to data table background once the thread
is done i can
assign and bind this data to my datagrid. I tried this
scenario but it's not
working for me. It's failing.

  I'll appreciate if some one can help me with the solution
or Any working
alternative solutions.

  Thanks
  Reddy

if your requirements indicate a user would need to interact
with each one of
a million rows of data at the same time, then you need to
shoot your
requirements person. (joke)

i can buy needing 100 rows for speed and caching maybe even
1000...but
beyond that, there's no good reason.

do not design the app to allow the user to access every
record at the same
time....

if this is non negotiable then
[1]install ms access for the client
[2]point it to the million row datasource
[3]teach the user to use the table browser
[4]bill a ridiculous sum of $$$
[5]retire




-----Original Message-----
From: Discussion forum for developers using Windows Forms to
build apps
and controls [mailtoOTNET-WI
NFORMSDISCUSS.DEVELOP.COM]On Behalf Of
Greg Robinson
Sent: Thursday, December 07, 2006 2:59 PM
To: DOTNET-WINFORMSDISCUSS.DEVELOP.COM
Subject: Re: [DOTNET-WINFORMS] Problem with loading the data
in
Datatables


Millions?  I would stop there, DataSetDataTables is not
designed to handle
this.


  -----Original Message-----
  From: Reddy G [mailto:reddy4allgmail.com]
  Sent: Thursday, December 07, 2006 2:57 PM
  To: DOTNET-WINFORMSDISCUSS.DEVELOP.COM; PStevensMULTICHOICE.CO.ZA;
pburrowsSTROMBERG.COM; gregCDS-AM.NET; ahmeda86hotmail.com;
ilyatumonline.microsoft.com; C.Meister-Chispeed.ch
  Subject: Problem with loading the data in Datatables


  Hi -

  I have a problem with loading the data in Datatables. I am
using vs.net
2003 environment. I have 10 Tables in my database. I am
loading 10 tables in
one dataset and creating relations for those Tables. Out of
10 tables one
table have millions of records and takes so much time to
load the data. Is
there any possiblity to load this data quickly or create a
thread which will
load this data in to data table background once the thread
is done i can
assign and bind this data to my datagrid. I tried this
scenario but it's not
working for me. It's failing.

  I'll appreciate if some one can help me with the solution
or Any working
alternative solutions.

  Thanks
  Reddy

The 10M table you're loading, is it related to one of the
other tables, or
is it the master table?

If you're selecting one record (record A) in another grid
and the 10M table
shows details for that record, why not just load records
related to record A
from the 10M table instead of loading all 1M records?

Best regards
 
Benny S. Tordrup
 
-----Oprindelig meddelelse-----
Fra: Discussion forum for developers using Windows Forms to
build apps and
controls [mailtoOTNET-WI
NFORMSDISCUSS.DEVELOP.COM] På vegne af Greg
Robinson
Sendt: 7. december 2006 20:59
Til: DOTNET-WINFORMSDISCUSS.DEVELOP.COM
Emne: Re: [DOTNET-WINFORMS] Problem with loading the data in
Datatables

Millions?  I would stop there, DataSetDataTables is not
designed to handle
this.


  -----Original Message-----
  From: Reddy G [mailto:reddy4allgmail.com]
  Sent: Thursday, December 07, 2006 2:57 PM
  To: DOTNET-WINFORMSDISCUSS.DEVELOP.COM; PStevensMULTICHOICE.CO.ZA;
pburrowsSTROMBERG.COM; gregCDS-AM.NET; ahmeda86hotmail.com;
ilyatumonline.microsoft.com; C.Meister-Chispeed.ch
  Subject: Problem with loading the data in Datatables


  Hi -

  I have a problem with loading the data in Datatables. I am
using vs.net
2003 environment. I have 10 Tables in my database. I am
loading 10 tables in
one dataset and creating relations for those Tables. Out of
10 tables one
table have millions of records and takes so much time to
load the data. Is
there any possiblity to load this data quickly or create a
thread which will
load this data in to data table background once the thread
is done i can
assign and bind this data to my datagrid. I tried this
scenario but it's not
working for me. It's failing.

  I'll appreciate if some one can help me with the solution
or Any working
alternative solutions.

  Thanks
  Reddy