Re: DataTable Limitations

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Miha Markic [MVP C#] (miha)
Date: 03/15/05 

Date: Tue, 15 Mar 2005 20:41:20 +0100

Hi Christopher,

I think that you will hit computer's memory limit way before you'll hit any
dataset limit.
That's why I don't think it is important.
However, if you want to be on the safe side, why don't you test it yourself
by adding columns, tables and rows? 

-- 
Miha Markic [MVP C#] - RightHand .NET consulting & development 
www.rthand.com
SLODUG - Slovene Developer Users Group www.codezone-si.info
"Christopher Luther" <cluther@n0sp@m.xybernaut.com.invalid> wrote in message 
news:eP8SFQZKFHA.244@TK2MSFTNGP12.phx.gbl...
>
> "Miha Markic [MVP C#]" <miha at rthand com> wrote in message 
> news:exET2cTKFHA.1308@TK2MSFTNGP15.phx.gbl...
>> Hi Christopher,
>>
>> Is this really important?
>>
> Yes, it is important.
>
> We've currently got a "process" that takes de-normalized data from SQL 
> Server, transforms the data into normalized tables (dynamically created), 
> and then used Excel to perform calculations on the data.
>
> There's LOTS of data, and we're hitting some hard limits within SQL 
> Server. The current thought goes something like "maybe se can eliminate 
> SQL Server as the repository of the normalized data and use an in-memory 
> DataSet to handle the normalized tables and such."  But before expending 
> $$$ on this "thought", we'd like to know any defined DataTable limits.
>
> - Christopher
>
>> -- 
>> Miha Markic [MVP C#] - RightHand .NET consulting & development 
>> www.rthand.com
>> SLODUG - Slovene Developer Users Group www.codezone-si.info
>>
>> "Christopher Luther" <cluther@n0sp@m.xybernaut.com.invalid> wrote in 
>> message news:%23VL9z8OKFHA.1540@TK2MSFTNGP14.phx.gbl...
>>> I've found a MSDN reference to the fact that an ADO.NET DataTable is 
>>> limited to 16,777,216 rows of data [1], but what I cannot find is a 
>>> reference for the maximum columns per DataTable, maximum bytes per 
>>> DataRow, etc.  Is this information documented anywhere?
>>>
>>>
>>> TIA!
>>>
>>> - Christopher
>>>
>>> [1] 
>>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemDataDataTableClassTopic.asp
>>>
>
>

Relevant Pages