| Subject | Re: [firebird-support] How does sweeping works? |
|---|---|
| Author | Daniel Vogelbacher |
| Post date | 2009-08-27T11:36:10Z |
On [Thu, 27.08.2009 12:51], Dimitry Sibiryakov wrote:
The query is slow, as far there is only one (active) record.
While count() runs, GC cleans up data & index (or not?).
Because the data (which slows down the query)
is generated by a rolled-back transaction,
I think I need to run a sweep before executing the SELECT
statement (or not?).
--
web: http://daniel.vogelbacher.name
irc: cytrinox @ (freenode|ircnet|quakenet)
> > In one of your last mails you wrote that sweep invokes GC.Uhmm, now I'm totally confused.
> > If I run a manual sweep every night, the select query
> > should run fast, isn't it?
>
> No. Speed of select isn't so much related to sweep or garbage collection.
The query is slow, as far there is only one (active) record.
While count() runs, GC cleans up data & index (or not?).
Because the data (which slows down the query)
is generated by a rolled-back transaction,
I think I need to run a sweep before executing the SELECT
statement (or not?).
--
web: http://daniel.vogelbacher.name
irc: cytrinox @ (freenode|ircnet|quakenet)