Thanks Sean,

I often respond to the forums while I am on the phone - sadly I rarely
get time these days where I am not distracted by something or another.
Thanks for the catch on the 32 million gaff on my part - chock that one
up to the fact that I am a little distracted today as we had a suicide
that landed outside the office window. Luckily it happened before most
of the office was in and only Tom and I witnessed it.

I am right now checking all my logic work as I am sure my error rate is
a few orders of magnitude higher due to how my day has been going so
far.

Anyways, I am surprised no one has noticed this problem before. I am
sure we are not the only company with large datasets which need to be
worked with in order to produce operational reports. It was not even a
large dataset.

I will ask on the devel list and run the same tests on the 2.5 Server to
see if the problem has been addressed.

best regards

Dalton

On Mon, 2008-11-24 at 13:57 -0500, Leyne, Sean wrote:
> Dalton,
>
> > I guess this is a support question vs a development question, as it
> > concerns an earlier version of Firebird.
>
> Given the details, I suspect that this might be an appropriate subject
> for the devel list.
>
> > Does anyone one know if there is a maximum number of inserts that
> can
> be
> > performed in a single transaction?
>
> Well, updating 32 million rows is not something that is "commonly
> done".
> So, thinking of this as the limit would not be surprising.
>
> > I am getting the error about the 32 million row mark and it strikes
> me
> > that is the area of a signed 32bit number.
>
> A 32 bit integer is significantly larger than 32 million (2 full
> orders
> of magnitude).
>
> [you were typing while you where on the phone, right? ;-) ]
>
> > 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?
>
> I can't think of any change which would have increased this "limit"
>
> Sean
>
>
>
>
>


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