Subject Re: [firebird-support] import data from external table (huge file)
Author Ann W. Harrison
Martijn Tonies wrote:
>
> So, the maximum number of rows in a Firebird table is just over 2 million?
>

No. The record number prior to version 2.0 is four bytes, or about
4gig. In fact, record numbers aren't dense - you get more small
records and fewer big records due to the way the numbers are allocated.
In V2, the record number is 40 bits (8 more orders of magnitude, base
2) and the number of possible records in a table is significantly huge.


Regards,



An