Subject Re: [firebird-support] Embedded Firebird : Transaction
Author Ann W. Harrison
Nando
>
> well I guess I need to find the cause; I am pretty sure about the
> symptoms and the cure, though. One huge transaction -> slow; many
> smaller transactions -> fast. Where should I look? Which factor I have
> slipped, if it's not RAM?

Gbak uses a transaction option "no_auto_undo" that does reduce memory
usage. Have you tracked the memory usage of your large inserts?

Regards,


Ann