Subject | Re: [firebird-support] import data from external table (huge file) |
---|---|
Author | Magnus Titho |
Post date | 2005-08-24T15:14:50Z |
Martijn Tonies wrote:
--
Magnus
>>>>it's not the size of the file, but the number of rows being read. The2^31 is around 2 billion, not 2 million - or am I missing something?
>>>>absolute number of row slots for a single table is 2^32 (just over 2
>>>>million). So - once the SP has walked past 2,147,483,648th row (or
>>>>
>>>>
>>>perhaps
>>>
>>>
>>>>a few less) the number is up, literally.
>>>>
>>>>
>>>So, the maximum number of rows in a Firebird table is just over 2
>>>
>>>
>million?
>
>
>Hmmm - 2 million rows per table is, well, not a whole lot ... :-/
>
>
--
Magnus