OK, I will try it out and let you know. Thx
--- In [email protected], 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] >
