Subject Re: [firebird-support] Slow performance with Index
Author Nick Upson
In article <BKEDKAAFAFBFNLODNMBLKEGGCLAA.eepstein@...>, III
Edwin A. Epstein wrote:
> It is necessary to process these in batch mode. I have several SP's that
> will set the process flag based upon multiple different criteria in the
> database.

How about running the relevant SP's from an update trigger, just for the
current record. That would spread out that part of the workload

--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly