Which is faster UniLoader or Batch Insert?

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
kneighbour
Posts: 77
Joined: Wed 08 Oct 2008 04:55

Which is faster UniLoader or Batch Insert?

Post by kneighbour » 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?
Top
ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Which is faster UniLoader or Batch Insert?

Post by ViktorV » Wed 01 Nov 2017 13:35

The similar question has already been discussed on our forum. Follow the link viewtopic.php?f=24&t=32899 for details.
Top
Post Reply

Return to “Universal Data Access Components”