Page 1 of 1

insert 1 million records into postgresql

Posted: Mon 04 May 2009 03:49
by Peter_Al
What is the best practice (in delphi) to insert 1 million records into postgresql database table?

Thanks.

Posted: Mon 04 May 2009 07:45
by Peter_Al
Sorry, i forgot to mention that the 1 million lines of records are read from a flat text file.

Thanks in advance.

Posted: Tue 05 May 2009 06:54
by Plash
If you are using UniDAC 2.50, we recommend using the TUniLoader component to load records.