Subject RE: [firebird-support] Why does a query take many times as long the first time it's run?
Author Leyne, Sean
Ann,

> Without the query (and any procedures it invokes) I can't say for certain that
> you're seeing garbage collection. It does seem odd that the second run also
> involves writes.

If an older transaction was committed between the execution of the 2 queries, would garbage collection not cleanup the versions for the newly committed transactions?


Sean