OK, I will try it out and let you know.

Thx

--- In firebird-support@yahoogroups.com, Ann Harrison <aharrison@...> wrote:
>
> On Wed, Apr 4, 2012 at 4:23 PM, esbreidenbach <scottb@...>wrote:
>
> >
> > The stored procedure is run as part of a desktop application. The purpose
> > of the procedure is to update two integer fields in a table. The values for
> > these fields are updated based on a number of other factors which I wont
> > bother you with, but suffice it to say that they change often. Whenever
> > the procedure is run, it would update approximately the same number of
> > records; the time of day does not affect the amount of "work" it has to do.
> >
> > The user runs the procedure often during the day. A connection to the
> > database is made when the user first logs in, so I am assuming that the
> > initial delay is not due to making a connection.
> >
> >
> What I'm looking for is an increasing difference between the Oldest Active
> Transaction and the Next Transaction.
>
> Good luck,
>
> Ann
>
>
> [Non-text portions of this message have been removed]
>