Re: [Geotools-devel] Slow inserts in DB

2015-10-19 Thread Jody Garnett
Patrick you may of seen a meeting reminder go out for a Skype meeting. Would you like to drop in to this meeting and chat? This looks to be very important work, thank you for taking it on. -- Jody Garnett On 19 October 2015 at 07:01, Patrick Valsecchi < patrick.valsec...@camptocamp.com> wrote: >

Re: [Geotools-devel] Slow inserts in DB

2015-10-19 Thread Patrick Valsecchi
I've been progressing a bit on that optimization. My work in progress can be found here: https://github.com/pvalsecc/geotools/tree/batch_inserts My status is: - All offline tests I can run are green: - Postgis - H2 - Mysql - Oracle - geogig Oracle export of a table w

Re: [Geotools-devel] Slow inserts in DB

2015-10-05 Thread Andrea Aime
On Mon, Oct 5, 2015 at 2:12 PM, Patrick Valsecchi < patrick.valsec...@camptocamp.com> wrote: > Is there any reason for not using batch inserts in JDBCDataStore#insert? > What do you think of changing this area in order to use batch inserts (same > for deletes and updates, too, I guess)? > No obje

[Geotools-devel] Slow inserts in DB

2015-10-05 Thread Patrick Valsecchi
Hi, 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. Geogig asks geotools to insert one feature at a time. As I was planning to fix that and gouping the insertions a bit, I've looked at how