Subject | Re: [firebird-support] Import - slower and slower commits |
---|---|
Author | Ivan Přenosil |
Post date | 2015-02-24T20:40:08Z |
> I have a huge table to import - tens millions of rows.There is no reason to not insert such amount of data in one transaction.
> From my experience, it is not good practice to commit job after importing everything, because import of rows can become slower and
> slower.
> So, i decided to make commit after every 50.000 rows. So far so good.
Firebird itself does not become slower and slower.
Most probably you have some badly optimized trigger.
I.