Subject | ODP: [firebird-support] Re: Strange behavior on very large table |
---|---|
Author | Karol Bieniaszewski |
Post date | 2019-03-02T09:50:19Z |
You have 91345 versions but Max versions is 1. Then i do not think that performance problem is here.
You have quite big fill 94%, that there is a chence that new page must be allocated – but here still you have free slots.
You have gap between oldest active nad next transaction. It is not big but you must look if this do not cause problem somewhere else
Which affect overall performance.
No more to say. I do not know anything about indexes, referencess and queries involved in this system.
Regards,
Karol Bieniaszewski