Hi, 1. I've deleted 500000 records from TABLE A. I've commited transaction. 2. I made SELECT * FROM TABLE A. Transaction was starting for a very long time.
I just wanted to make sure that there is no way to prevent this behaviour? I mean, I can not delay somehow clearing of this garbage? As far as I understand this article: http://www.firebirdsql.org/manual/gfix-housekeeping.html http://www.firebirdsql.org/manual/gfix-housekeeping.html there is no such possibility becasue: "Whenever a subsequent transaction reaches garbage from a committed transaction, that garbage is automatically cleared out."
