Subject Re: [firebird-support] Knowing the previous rows
Author Walter R. Ojeda Valiente
Well, after run GSTAT and reading the output I can see how many garbage a whole table has, but it don't shows me the "story" of a row. ┬┐How many COMMITs and how many ROLLBACKs the row with ID 1234 of the table CLIENTS had had?

Greetings.

Walter.


On Fri, Aug 7, 2015 at 1:42 PM, Walter R. Ojeda Valiente <sistemas2000profesional@...> wrote:
Thank you Ann, I shall investigate that.

Greetings.

Walter.


On Fri, Aug 7, 2015 at 1:10 PM, Ann Harrison aharrison@... [firebird-support] <firebird-support@yahoogroups.com> wrote:
 




The idea is to know how many garbage a table has. Or several tables. Or the whole database.


That you can find out with gstat.  It won't tell you how bad each record is, but it will tell you the total number of back version, average, min, and max chain lenght.

Then you can set up triggers (if you want) on troublesome tables.

Good luck,

Ann