Re: [Geotools-devel] Performance problems on JDBCFeatureStore removeFeatures

2014-05-09 Thread Mauro Bartolomeoli
Hi, I prepared a pull request with the suggested optimizations, if someone wishes to have a look at it: https://github.com/geotools/geotools/pull/450 Mauro 2014-04-24 11:05 GMT+02:00 Jody Garnett jody.garn...@gmail.com: All your suggestions sound good, the locking manager is intended to be

[Geotools-devel] Performance problems on JDBCFeatureStore removeFeatures

2014-04-24 Thread Mauro Bartolomeoli
Hi, recently we hit a performance issue using the JDBCFeatureStore removeFeatures method. The problem is in the JDBCDataStore ensureAuthorization call that is checking if all the features can be removed (no locks on them). We launched a removeFeatures with a Filter.INCLUDE filter on a 1.000.000

Re: [Geotools-devel] Performance problems on JDBCFeatureStore removeFeatures

2014-04-24 Thread Jody Garnett
All your suggestions sound good, the locking manager is intended to be pluggable, so you can implement locking in SQL if your database supports it. Jody Garnett On Thu, Apr 24, 2014 at 6:53 PM, Mauro Bartolomeoli mauro.bartolome...@geo-solutions.it wrote: Hi, recently we hit a performance