Re: [Qgis-developer] Grouping insert/update when sending to PostGIS
Hi Rémi, On Thu, 28. May 2015 at 12:06:22 +0200, Rémi Cura wrote: When making several edit on the layer, then saving the edits. All the edits are send one by one to the database (though in the same transaction). That's because of the provider interface. For vector data providers addFeatures, deleteFeatures, changeAttributeValues and changeGeometryValues are independant operations - which therefore are also done in separate transactions. Jürgen -- Jürgen E. Fischer norBIT GmbH Tel. +49-4931-918175-31 Dipl.-Inf. (FH) Rheinstraße 13 Fax. +49-4931-918175-50 Software Engineer D-26506 Norden http://www.norbit.de QGIS release manager (PSC) GermanyIRC: jef on FreeNode signature.asc Description: Digital signature ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Grouping insert/update when sending to PostGIS
Hey Jürgen, this doesn't explain why each operations isn't grouped. For instance all the addFeatures are grouped into one transaction, but not into one statement. Cheers, Rémi-C 2015-05-28 16:39 GMT+02:00 Jürgen E. j...@norbit.de: Hi Rémi, On Thu, 28. May 2015 at 12:06:22 +0200, Rémi Cura wrote: When making several edit on the layer, then saving the edits. All the edits are send one by one to the database (though in the same transaction). That's because of the provider interface. For vector data providers addFeatures, deleteFeatures, changeAttributeValues and changeGeometryValues are independant operations - which therefore are also done in separate transactions. Jürgen -- Jürgen E. Fischer norBIT GmbH Tel. +49-4931-918175-31 Dipl.-Inf. (FH) Rheinstraße 13 Fax. +49-4931-918175-50 Software Engineer D-26506 Norden http://www.norbit.de QGIS release manager (PSC) GermanyIRC: jef on FreeNode ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Grouping insert/update when sending to PostGIS
Hi Rémi, On Thu, 28. May 2015 at 17:07:32 +0200, Rémi Cura wrote: this doesn't explain why each operations isn't grouped. For instance all the addFeatures are grouped into one transaction, but not into one statement. addFeatures does one prepared INSERT statement. Jürgen -- Jürgen E. Fischer norBIT GmbH Tel. +49-4931-918175-31 Dipl.-Inf. (FH) Rheinstraße 13 Fax. +49-4931-918175-50 Software Engineer D-26506 Norden http://www.norbit.de QGIS release manager (PSC) GermanyIRC: jef on FreeNode signature.asc Description: Digital signature ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer