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