Thomas Steinmaurer wrote:

>>
>> Does anyone one know if there is a maximum number of inserts that can be
>> performed in a single transaction?
>>
>
> Possibly. From the Firebird 2.0 Release Notes p.10:
>
> 40-bit (64-bit internally) record enumerators have been introduced to
> overcome the ~30GB table size limit imposed by 32-bit record enumeration.
>
> Although, I can't say for sure that your particular problem has been
> fixed. ;-)

That problem showed up as a pointer page not found - if I remember
correctly, the problem was an overflow in the decomposition of a
record number into offset in the list of pointer pages, offset on
pointer page, and offset of the index on the data page. Dalton is
getting an out of memory error from sort... Is there an index?
(That shouldn't cause a sort, but ...) or any other reason to sort
the data?

Cheers,

Ann