Which is faster UniLoader or Batch Insert?
Posted: Tue 31 Oct 2017 23:38
I am using UniDac 7.1 (? the latest, anyway) in Delphi XE7. I have been using the UniLoader to good effect to load a lot of records into Firebird 3. I have recently started to use the Batch insert/update/delete functions in UniQuery and this has been helpful.
In my current FB database I am processing about 335K records and this is taking about 30 minutes and this is not good enough. I was thinking to put the Batch Insert functions into the UniLoader, but since this is a fair bit of work, was wondering if the speed difference was worth it? ie which is faster UniLoader or Batch Insert?
In my current FB database I am processing about 335K records and this is taking about 30 minutes and this is not good enough. I was thinking to put the Batch Insert functions into the UniLoader, but since this is a fair bit of work, was wondering if the speed difference was worth it? ie which is faster UniLoader or Batch Insert?