|Subject||RE: [firebird-support] Some performance problems.|
> -----Original Message-----Not that I'm aware of.
> 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?
> 2) Is it ok to commit the transaction after every INSERT, orIt depends on how many inserts, tbh you are probably better inserting the
> will it create a performance problem for the INSERT?
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 wrongNot sure if it will help, but take a look at
> but I can't find any good esplanation about using
> transactions in firebird )
(http://www.fbtalk.net/viewtopic.php?id=257) which is what I use as a base
class for the DB layer in firebird/.net apps. There are two template procs,
one uses a reader, the other is used for sp execution and a couple of
wrapper functions to make life easier.
http://www.fbtalk.net/ - Web Based Firebird Forum
http://www.tectsoft.net/ - Homepage