What are the limitations of a .Net dataset and datatable like
Maximum number of rows ?, Maximum number of columns in datatable?.
Is there any of these limitations improved in .Net 2.0
Thanks
vinothkumar
Hi,
Datatable max rows - 16,777,216
Can't seem to find the max columns. But I guess its still the same...
IMHO, the real limitation would be on your hardware. I think its impossible for a low-end cpu to reach the limits of the datatable and dataset objects...
cheers,
Paul June A. Domag
Paul is correct. Its still the same with v2.0 of .NET Framework also.
Thats been documented here for v2.0:
http://msdn2.microsoft.com/library/9186hy08(en-us,vs.80).aspx
Regards,
Vikram
I have found some links which says its possible to store a billion rows ...
but as paul said .. the documentation says its limited to 16,777,216...
The documentation is in Beta .. so would it change?
http://codebetter.com/blogs/sahil.malik/archive/2005/03/19/60093.aspx
->http://codebetter.com/blogs/raymond.lewallen/archive/2004/12/09/35809.aspx
->http://dotnetjunkies.com/WebLog/rlewallen/archive/2004/12/03/34841.aspx
check out the links
Thanks
vinothkumar
Hi,
A blog in your link talks about the datarows backbone being changed from arraylist into something much more faster. So my answer is yes. This could change. If Microsoft changes the style in which a datarow is stored then there's a pretty much chance that they'r gonna increase the limit also...
cheers,
Paul June A. Domag
The backend DB has one row limit and the client side has another. The addressable limit is usually way beyond what typical hardware can handle on either side.
If you are draging more that a few MBs of row data to the client you may want to look at alternatives.
vinxter wrote:
hi all ..
I have found some links which says its possible to store a billion rows ...
but as paul said .. the documentation says its limited to 16,777,216...
The documentation is in Beta .. so would it change?
http://codebetter.com/blogs/sahil.malik/archive/2005/03/19/60093.aspx
->http://codebetter.com/blogs/raymond.lewallen/archive/2004/12/09/35809.aspx
->http://dotnetjunkies.com/WebLog/rlewallen/archive/2004/12/03/34841.aspx
check out the links
Thanks
vinothkumar
Thank you for quoting me vinoth. IMO this is a good read too - http://codebetter.com/blogs/sahil.malik/archive/2005/08/04/130264.aspx
Sahil Malik [MVP C#]
Author: Pro ADO.NET 2.0
http://www.winsmarts.com
