December 17, 2008 at 9:23 pm
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.
December 17, 2008 at 11:51 pm
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
December 18, 2008 at 6:37 am
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply