Subject Re: Odp: [firebird-support] Performance with heavily updated table
Author Thomas Steinmaurer
Tim,

> I believe the relevant part of the gstat output for the table in
> question to be as below, please let me know if I've got that wrong.
> (Names changed but otherwise unaltered.) My interpretation, which may be
> faulty, of
>
> Average version length: 0.00, total versions: 0, max versions: 0
>
> is that there are no versions of records lying around, so none of the
> explanations of the performance so far, all of which I think involve
> multiple versions in some way, is correct.
>
> What would you like to see from the MON$ tables?

We can try to investigate your issue via one of our tools. Please
contact me offline.



--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.