Subject Re: [firebird-support] Why does a query take many times as long the first time it's run?
Author Ann Harrison
On Tue, Aug 27, 2013 at 12:32 PM, Leyne, Sean <Sean@...>wrote:

> 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?

Yes, but if I were trying to demonstrate the behavior of a single statement
run twice, I probably
wouldn't do it when there's other stuff going on in the database.



[Non-text portions of this message have been removed]