Hi All,

I guess this is a support question vs a development question, as it
concerns an earlier version of Firebird.

Does anyone one know if there is a maximum number of inserts that can be
performed in a single transaction?

I am using Firebird 1.54 and I am processing a small sub-set of records
(about two months worth), selecting them in natural order, performing a
task upon the data and then inserting the final results into a separate
table.

I am getting "insufficient memory for sort operation" when I am running
the process. I have 50 GB of free space on my temp area, 16 GB of Ram
and only one process running on the machine.

I am getting the error about the 32 million row mark and it strikes me
that is the area of a signed 32bit number.

Is this a known limit to the number of DML within a single transaction?
If I break it up to span two transactions, my problem goes away.
If this is a known limit, has it been removed in more recent versions of
Firebird?

Thanks

Dalton


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