Re: psql COPY with JDBC

Hi, Christopher,

Christopher Condit wrote:
> Yes, that's true, but isn't it significantly faster to use the bulk
> loader for many records.

Have you tried the following:

Use a Prepared Statement for the insert, then addBatch() it and
executeBatch() it at the end, with autocommit off?

This should be the fastest non proprietary way to load data into a database.

HTH,
Markus

--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org