On 14 February 2012 00:54, Omi Chiba <ochib...@gmail.com> wrote: > I have a problem with the performance of CSV import and I assume it > generate INSERT statement for every record so it will be 8000 > statement if you have 8000 records in csv file. > > Can we use bulk_insert method instead so there will be always only one > INSERT statement which should reduce the performance significantly ? > > As I understand it the database (at least Postgresql) uses the COPY statement to import csv-files. That is much quicker than a series of individual inserts.
Regards Johann -- Because experiencing your loyal love is better than life itself, my lips will praise you. (Psalm 63:3)