Subject Re: [firebird-support] Re: Embedded Firebird : Transaction
Author Nando Dessena

A> 1. Forced writes off, if the thing bombs, who cares.
A> 2. Embedded is much faster
A> 3. Disabling indices
A> 4. Disabling triggers where applicable
A> 5. Disabling constraints
A> 6. Get a good balance between the time it takes to commit and start a
A> transaction against the resources it takes to manage the savepoint
A> logs.


A> For inserts after the database is being used, do not use any of the
A> above suggestions.

well, 2) still applies. ;-)
And sometimes 3) as well.

Nando Dessena
I support Firebird, I am a Firebird Foundation member!
Join today at