insert 1 million records into postgresql

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Peter_Al
Posts: 2
Joined: Mon 04 May 2009 03:45

insert 1 million records into postgresql

Post by Peter_Al » Mon 04 May 2009 03:49

What is the best practice (in delphi) to insert 1 million records into postgresql database table?

Thanks.
Top
Peter_Al
Posts: 2
Joined: Mon 04 May 2009 03:45

Post by Peter_Al » Mon 04 May 2009 07:45

Sorry, i forgot to mention that the 1 million lines of records are read from a flat text file.

Thanks in advance.
Top
Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Tue 05 May 2009 06:54

If you are using UniDAC 2.50, we recommend using the TUniLoader component to load records.
Top
Post Reply

Return to “Universal Data Access Components”