I concur. In the most general case, any transaction that last more than
1/10 of a second is worth seriously reviewing in my books.

On Wed, 2006-03-08 at 12:13 +0000, Si Carter wrote:
>
>
> > -----Original Message-----
> > Just to add a little weight to this question, we also have
> > the same issue.
> >
> > It would be great if there was a way to see which user was
> > locking a record so that the administrator could give them a
> > little nudge to rollback or commit their transaction. It
> > would be even nicer if the transaction could be
> > committed/rolledback by SYSDBA.
>
> Although seeing who has what locked would be useful, isn't it a
> question of
> design, to me, and I may very well be alone in this, the life of a
> transaction should be as short as humanly possible to get the job
> done.
> There shouldn't be a need to keep a transaction open for
> hours/days/weeks
> etc.
>
> Rgds
>
> Si Carter
> http://www.fbtalk.net/ - Web Based Firebird Forum
> http://sourceforge.net/projects/fbutils - FBUtils
> http://sourceforge.net/projects/dnfbb - Web based, Firebird Powered
> Forum
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
>
> SPONSORED LINKS
> Technical support
> Computer technical
> support
> Compaq computer
> technical support
> Compaq technical
> support
> Hewlett packard
> technical support
> Microsoft technical
> support
>
>
> ______________________________________________________________________
> YAHOO! GROUPS LINKS
>
> 1. Visit your group "firebird-support" on the web.
>
> 2. To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
> 3. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
>
>
> ______________________________________________________________________
>