Subject RE: [firebird-support] Some performance problems.
Author Ariel Sakin
Thanks! It looks very helpful.

-----Original Message-----
[] On Behalf Of Si Carter
Sent: Tuesday, November 15, 2005 2:34 PM
Subject: RE: [firebird-support] Some performance problems.

> -----Original Message-----
> Your shot in the dark hit the target.
> I do not have a commit after the insert.
> The problem is I never do "BeginTransaction" in my program.
> So I don't have the option to commit as far as I understand.
> If I look at the FbConnection object, I see that the
> activeTransaction is always null.
> 1) Is there a way to tell the Database to commit itself after
> a certain number of INSERTs?

Not that I'm aware of.

> 2) Is it ok to commit the transaction after every INSERT, or
> will it create a performance problem for the INSERT?

It depends on how many inserts, tbh you are probably better inserting
lot in one transaction, if you are going to split it you might want to
commit every 5000 or so inserts.

> What am I doing wrong???? (I know I am doing something wrong
> but I can't find any good esplanation about using
> transactions in firebird )

Not sure if it will help, but take a look at
( which is what I use as a
class for the DB layer in firebird/.net apps. There are two template
one uses a reader, the other is used for sp execution and a couple of
wrapper functions to make life easier.


Si Carter - Web Based Firebird Forum - Homepage


Visit and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at


Yahoo! Groups Links