Martijn Tonies wrote:

>>>>>>it's not the size of the file, but the number of rows being read. The
>>>>>>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 ... :-/
>>>
>>>
>>
>>2^31 is around 2 billion, not 2 million - or am I missing something?
>
>
> Hmm, right. I guess both Helen and me are missing something :-)

Yeah...And this is why "select count(*) from <table>" is still needed
for Firebird database :-(


Regards
Boguslaw Brandys