no triggers, no indexes on the table.
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.
There is no reason to not
Hi,
There is a fix in 254 snapshot for similar problem.
Download fresh 2.5.4 Firebird snapshot and try it.
Regards,
Alexey Kovyazin
IBSurgeon
Firebird Recovery service:
http://ib-aid.com/en/firebird-interbase-recovery-service/
Database Performance optimization:
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
Aleksey,
What I did is:
Stopped firebird 2.5.3 server
Renamed bin folder to bin orig
copied BIN folder from zip file I downloaded (snapshot 2.5.4)
started firebird server
Checked server vesrion - it says 2.5.4.26842
Continuing import after 72.000.000 rows, now I get folowing timings:
100.000
Hi Aleksey,
Thanks for the reply.
Should I just uninstall, install other version, or I should aslo do backup /
restore ?
regards,
Zoran
