Re: Limit in Dataset?

From: Val Mazur (group51a_at_hotmail.com)
Date: 11/09/04 

Date: Tue, 9 Nov 2004 18:58:26 -0500

Hi,

I believe DataTable could hold up to 2,147,483,648 rows. I have a dataset
with 80,000 rows in it and it works fine. It does not mean it is a good idea
to load dataset with the whole table from the database, but in some case
(like mine) you need to load data from the XML file, not from the database
and you will be able to load big dataset. Performance depends on a design of
the application. If you retrieve data from the database, then try to select
only rows, which you really need. If you have loaded big DataSet, then it
works pretty fast even with thousands rows in it. From my personal
experience I was able to write code, which joined DataTable in a DataSet
and it produces around 3,500,000 joined rows in approx 40 seconds. 

-- 
Val Mazur
Microsoft MVP
"LJ" <LJ@discussions.microsoft.com> wrote in message 
news:82397EA5-BC8E-46DE-8BEB-F53047C7CE09@microsoft.com...
> Hi,
> Could somebody tell me whether there is a limit in the no. of records that 
> a
> Dataset/Dataset tables can  handle? I read in a book that Dataset is not a
> good option if you have more than 200 records.
>
> Thanks
> LJ

Relevant Pages

  • Re: Limit in Dataset?
    ... > "Val Mazur" wrote in message ... >> idea to load dataset with the whole table from the database, ... >> case you need to load data from the XML file, ... >> database and you will be able to load big dataset. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Generating one table with a terabyte of data
    ... I didn't know we could split a database file group over multiple HDs. ... > Run perfmon counters to a log and analyze them after a bulk load. ... Another thing is to split the updates across file sets. ... >> loading of daily data in the fastest time. ...
    (microsoft.public.sqlserver.dts)
  • Re: Limit in Dataset?
    ... - Sahil Malik ... > idea to load dataset with the whole table from the database, ... > case you need to load data from the XML file, ... > database and you will be able to load big dataset. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ORACLE RAC and ORACLE Standby
    ... standby is better for disaster recovery and RAC is ... with taking any downtime on your primary database instance. ... The standby database provides a local or off-site recovery instance. ... Load balancing capabilities of RAC include ...
    (comp.databases.oracle.server)
  • Re: Poser? What happens to empty pages in a database unload/load?
    ... At my company, several time each weekend, a database is unloaded at ... squeezed out of the load. ... I unload the table and load it back and now all those empty pages are ... Art S. Kagel ...
    (comp.databases.informix)