Roughly how far apart can the oldest transaction and the Next
transaction be before you know you have a problem.

Also, what is meant by Oldest Transaction as opposed to the Oldest
Active? That is, what makes a transaction active? Is there a timeout
value when an 'active' transaction turns non active?

Regards
Colin

-----Original Message-----
From: Svein Erling Tysvaer
[mailto:svein.erling.tysvaer@...]
Sent: Thursday, 12 June 2003 10:08 p.m.
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Difference between Oldest Active and Next
Transaction


Not if all those 6517 transactions are read-only, but for each update,
insert (or delete?) the transactions have done, duplicates of all
changed/inserted records are created due to the changes being visible
for
only some of the transactions. And this affects the performance of the
database. Hence, it is a good idea to ascertain that the oldest
transaction
is moving on.

Set

At 09:36 12.06.2003 +0000, you wrote:

>If the difference between oldest active and next transaction is
>increasing, will it effect the performance of the database (for sql
>query)?
>
>eg.
>Oldest Transaction 2248862
>Oldest Active 2248868
>Oldest snapshot 2248868
>Next transaction 2255385
>
>diff = 6517
>
>rgds, chooi-ting

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/



######################################################################
Attention:
The information in this email and in any attachments is confidential.
If you are not the intended recipient then please do not distribute,
copy or use this information. Please notify us immediately by return
email and then delete the message from your computer.
Any views or opinions presented are solely those of the author.
######################################################################