Subject | Re: Optimizing TIBOTable inserts |
---|---|
Author | kgdonn |
Post date | 2006-06-28T21:39:45Z |
I haven't made much headway with this. The code I posted earlier runs
in about 1:15 on my machine. I found if I do
IBODatabase1.AutoCommit:=false and then do my own IBODatabase1.Commit
after the loop, it goes down to about 0:33. Faster, but still not
fast by any means. At this point, I'm a little desperate. What's the
fastest way to add tens-of-thousands of records to a Firebird table
through IBO with no constraints at all?
Thanks,
Kevin Donn
in about 1:15 on my machine. I found if I do
IBODatabase1.AutoCommit:=false and then do my own IBODatabase1.Commit
after the loop, it goes down to about 0:33. Faster, but still not
fast by any means. At this point, I'm a little desperate. What's the
fastest way to add tens-of-thousands of records to a Firebird table
through IBO with no constraints at all?
Thanks,
Kevin Donn