On Thu, Oct 11, 2012 at 1:43 PM, unordained <unordained_00@...>wrote:

>
>
> The reasoning behind automatic GC is that, while it slows some operations
> down
> at first (one-time cost), it speeds many others up later. Can you tell
> which
> aspect is really slowing you down? After your inserts, are selects
> initially
> slow, then faster? And you're sure it's a GC issue, not an indexing issue,
> or
> the cost of cacheing data into memory?
>

Those are good points.

>
> There may be a mode where FB doesn't bother creating back-versions of
> records
> for other transactions to read,

No, there is no such mode. Record versions are the Firebird undo log.
Without them, transactions can roll back and multi-row updates can't be
cleaned up.

The post continues with useful suggestions.

Good luck,

Ann


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