Hi Group, I have a huge table to import - tens millions of rows. 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. Now I am at 70.000.000 rows imported. Import of 50.000 rows last about 35 seconds = 1.428 records / second - excellent. Commit of these 50.000 rows now takes about 85 seconds, with tendency to last longer and loner. So my import probably will never finish :( . Before I stop everything, and start again by splitting import process in few steps, can someone explain why this is happening ?
Regards, Zoran
