On 7-8-2015 22:50, 'Walter R. Ojeda Valiente'
sistemas2000profesio...@gmail.com [firebird-support] wrote:
I just was a bit curious about that possibility, which seems interesting
for audit tables and more yet, users.
By design, very few UPDATEs and DELETEs there are on my databases
because I
On Aug 7, 2015, at 1:56 PM, 'Walter R. Ojeda Valiente'
sistemas2000profesio...@gmail.com [firebird-support]
firebird-support@yahoogroups.com wrote:
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
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
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
Thank you Ann, I shall investigate that.
Greetings.
Walter.
On Fri, Aug 7, 2015 at 1:10 PM, Ann Harrison aharri...@ibphoenix.com
[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.
...@gmail.com
[firebird-support] firebird-support@yahoogroups.com
Data: 06.08.2015 20:12 (GMT+01:00)
Do: firebird-support@yahoogroups.com
Temat: [firebird-support] Knowing the previous rows
Hello everbody
Always that a transaction that did an UPDATE ends with a COMMIT or a
ROLLBACK
Temat: [firebird-support] Knowing the previous rows
Hello everbody
Always that a transaction that did an UPDATE ends with a COMMIT or a ROLLBACK
this left back a row.
So, my question is: There is some way to know those previous rows?
This can be very useful for me