Subject Re: [firebird-support] Very long transaction start after deleting a big number of records.
Author Carlos H. Cantu
Post date 2014-07-25T13:56:10Z
Re: [firebird-support] Very long transaction start after deleting a big number of records. It seems that Firebird 3 may have TRUNCATE table statement, that will drop the table and avoid GC on its pages:

http://tracker.firebirdsql.org/browse/CORE-2479

Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br


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
 
there is no such possibility becasue:

"Whenever a subsequent transaction reaches garbage from a committed transaction, that garbage is automatically cleared out."