Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Dataset doubt Expand / Collapse
Author
Message
Posted Wednesday, December 17, 2008 9:23 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, August 9, 2009 11:55 PM
Points: 24, Visits: 76

what is the max. number of tables we can store in a dataset
what is the max. number of rows we can store in a dataset table
what is the max. number of columns we can store in a dataset table


Also if i have some millions of records in the db, is it an efficient mechanism to transfer the records to the front end in a single dataset or is there any other mechanism we need to adopt.
Post #621764
Posted Wednesday, December 17, 2008 11:51 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, December 20, 2010 4:47 AM
Points: 42, Visits: 141
1. The maximum size is limited by Int32. So 2^32 is the maximum number of DataTables you can hold inside a DataSet. So the max size is 2 billion.

2. The maximum number of rows that a DataTable can store is 16,777,216

3. The maximum number of columns per base table is 1024.


"I Love Walking In The Rain So No One Can See Me Crying ! " ~ Charlie Chaplin
Post #621806
Posted Thursday, December 18, 2008 6:37 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:50 PM
Points: 13,752, Visits: 28,150
Why on earth would you need millions of records in a front-end app? People won't even read thousands of records. Most people don't go past the first screen, except to go to the last screen to look at totals, which you could provide independently.

BTW, Open your local copy of Books Online and past this into it (ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10sq_GetStart/html/13e95046-0e76-4604-b561-d1a74dd824d7.htm). That shows you all the maximum values.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #622003
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse