-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thursday 09 October 2003 09:59, Helen Borrie wrote:
> At 07:22 AM 9/10/2003 +0000, you wrote:

> For a rough idea of what's happening, use SHOW DATABASE in isql. The thing
> to pay attention to is the gap between "Transaction - oldest" and
> "Transaction - next". As a guideline, the gap should be approximately
> equal to the number of active users (or less). Watch that gap - if you see
> the db slowing down at a similar rate to the growth of the gap, then you
> have your answer.
>
> Huge bulk deletes can cause a buildup of back versions too.
>
> heLen
>
Hi Helen,
I noticed that in one of my db's (which is accessed by a php app) the OIT -
next gap is around 1500. but using gfix -l on the db does not list
anything... how can i see what are these transaction about?

thanks

- --
Francesco Lamonica: f DOT lamonica AT tin DOT it

PGP Fingerprint: 5870 92BA 8DFF 1ACF DE2E B94D 46EC 5505 7C64 4EF1
Favourite quote: There's no spoon
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQE/hUDsRuxVBXxkTvERAi/qAJ0T5QAoi9di0xys7Bv4E5F1KD9YVgCgp+hv
E6AfzhUMtZ8PauxRcblq5A4=
=AV2I
-----END PGP SIGNATURE-----