Subject | Re: [firebird-support] Re: High volume of INSERT/DELETE operations |
---|---|
Author | Dimitry Sibiryakov |
Post date | 2008-12-16T12:01:28Z |
> I had one open connection that was left open for few hours and it keptMay be this connection (actually - transaction inside it) was the
> the oldest fields so low.
reason why database grown?..
> Oldest transaction 96722Perfect statistic. If it always looks like this, sweep will never occur.
> Oldest active 96723
> Oldest snapshot 96723
> Next transaction 96724
Perhaps (because of CS) there is no queries which would collect garbage.
I would return automatic sweep interval to default value and run
manual sweep nightly. Or just occasional queries like SELECT COUNT(*)
FROM TABLE to collect garbage. Or backup.
SY, SD.