[Geotools-devel] [JIRA] (GEOT-5264) Improve big dataset inserts in DB

[Patrick Valsecchi (JIRA)]

Title: Message Title

Patrick Valsecchi created an issue   GeoTools / GEOT-5264 Improve big dataset inserts in DB Issue Type: Improvement Affects Versions: 15-beta Assignee: Unassigned Components: jdbc Created: 23/Oct/15 2:54 PM Environment: Any database Priority: Medium Reporter: Patrick Valsecchi Original Estimate: 1 week Remaining Estimate: 1 week I'm using geogig to import/export data from/to Oracle. As I was a bit surprised by the slowness of the export operation, I've looked a bit at how it's done. Basically, in JDBCDataStore#insert, Geotools loops over the features to insert and, for every feature, will do that: Do a "select max(key)+1 from table" to get the next value to use Create a PreparedStatement with bound variables execute it close the PreparedStatement That is very inefficient. When doing a lot of inserts in JDBC, one should use addBatch and executeBatch. Add Comment   This message was sent by Atlassian JIRA (v7.0.0-OD-08-002#70107-sha1:3f098e8)

------------------------------------------------------------------------------

_______________________________________________
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel