Hi Ann,

Nope, no sort, natural order result set, but Alex and Pavel both think
the problem has to do with the undo log.

I have taken the issue to the devel list.

Thanks

Dalton

On Mon, 2008-11-24 at 15:54 -0500, Ann W. Harrison wrote:
> 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
>
>
>
>
>


[Non-text portions of this message have been removed]