Max Limit on rows in DataTable

  • Thread starter Thread starter Kapil Joshi
  • Start date Start date
K

Kapil Joshi

Hi All,

I would like to know if there is any upper limit on the number of rows that
a datatable can contain?

Thanks in advance.

~ Kapil
 
Kapil:

I found the link before but can't seem to find it now. It's a very very
large number and for all intents and purposes, well over anything that you
would ever want to use (I know it was over 5 million)..but let me find the
documentation first.
 
Thanks a lot William ! ..
Pls. do post the documentation in case you happen to find it.

Thanks
~ Kapil
 
¤ Hi All,
¤
¤ I would like to know if there is any upper limit on the number of rows that
¤ a datatable can contain?
¤

I'm not aware of any numerical limit that you will ever conceivably encounter. You're more likely to
encounter memory and performance issues before you encounter any numerical limit.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Hi William,

Good link.
It sounds to me like it has Int24 limit on rows count :)
 
While there is an actual number, Paul's point is absolutely correct, b/c
with that amount of data you would probably need some real horsepower to use
it and it's hard to imagine a scenario where you'd ever want to handle that
much data locally. Also, 16+ million rows with 2 columns would be a lot
less resource intensive than 16 million + rows with 60 columns, so in
practice, the 'limit' has a lot more to do with physical resources than any
limit inherent in the datatable.
Paul Clement said:
¤ Hi All,
¤
¤ I would like to know if there is any upper limit on the number of rows that
¤ a datatable can contain?
¤

I'm not aware of any numerical limit that you will ever conceivably
Click to expand...
encounter. You're more likely to
Click to expand...
 
Back
Top