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

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.

<SNIP>

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.

Ciao
--
Nando Dessena
http://www.flamerobin.org
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================