Subject | Re: [firebird-support] Re: Embedded Firebird : Transaction |
---|---|
Author | Nando Dessena |
Post date | 2005-09-21T05:22:01Z |
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
======================================================
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
======================================================