Hi Set

> Yes Paul,
> I'd say you do have a problem.

OK - at least I know that now ;-/

>
> My guess is that this is not a read-only transaction, since it is easy
> to teach people that they have to commit for their changes to be
> visible. Maybe someone is monitoring your system, never turning their
> computers off?

Certainly some people never turn off their computers, and maybe don't even
log out of my app, but things should still get committed.

>
> You also have another problem that you do not know about: OAT issues
> has nothing to do with IBO, so you should move this subject over to
> the ib-support forum.
>

Are you sure about that? I have suspician there are many ways of missusing
IBO to produce OAT problems - I just dont understand it in enough detail. I
will try ib_support anyway.

Thanks
Paul

> HTH,
> Set
>
> --- In IBObjects@yahoogroups.com, "Paul Hope" wrote:
> > Hi
> >
> > I suspect I have OAT problems and would appreciate some help as to
> > where to look.
> >
> > This is an extract from DB Stats
> >
> > Oldest transaction 983067
> > Oldest active 983068
> > Oldest snapshot 983067
> > Next transaction 1752712
> >
> > If this is OK then I can stop worrying, however I think it means
> > that there are some 770,000 transactions active - which doesnt sound
> > reasonable :-(
> >
> > The default transaction is set to AutoCommit and ReadCommitted.
> This is used by
> > - All read transactions
> > - All trivial single update transactions
> >
> > All multiple updates use their own IB_Transaction (not AutoCommit,
> ReadCommitted) and the code contains a StartTransaction and
> Commit/Rollback in a try/except block. There is never any oportunity
> for the user to hold up the process between the two.
> >
> > Forms that do not use data aware components are loaded using an
> IB_Cursor with everything as default except for the IB_Connection and
> the SQL. I will call First, read the data to EOF, then probably
> leave the IB_Cursor and let it be destroyed with the form.
> >
> > Forms that do use data aware controls use the IB_Query with update
> SQL and the default transaction. Some of these use grids, and some of
> those are master detail connected to potentially large tables.
> Sometimes the forms have their own AutoCommit transaction object.
> >
> > Any suggestions as to how I go about sorting this would be greatly
> appreciated.
> >
> > ( IB 5.6, D6, IBO4.2Ie)
> >
> > Regards
> > Paul
>
>
>

___________________________________________________________________________

> IB Objects - direct, complete, custom connectivity to Firebird or

InterBase

> without the need for BDE, ODBC or any other layer.
>

___________________________________________________________________________

> http://www.ibobjects.com - your IBO community resource for Tech Info

papers,

> keyword-searchable FAQ, community code contributions and more !
>
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/IBObjects/
>
> To unsubscribe from this group, send an email to:
> IBObjects-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to:
> http://docs.yahoo.com/info/terms/
>
>