|Subject||Re: [firebird-support] Updating/Inserting is slower and slower|
-----BEGIN PGP SIGNED MESSAGE-----
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.
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?
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)
-----END PGP SIGNATURE-----