Forwarding Nyall tips, might be usefull for others

> I tested drag and drop in browser and dbmanager (in 2.18.7 and master) and
> couldn't find anything about that in the issues or the code base.

Both of these codepaths use QgsVectorLayerExporter, which batches
calls to QgsVectorDataProvider::addFeatures in groups of 200 features.
So there's definitely the potential for a good speed bump here by
moving to the COPY command.

> Did I miss something? Is there someone working in that area?

I don't think so. The tricky bit would be handling the "RETURNING"
part of the INSERT command, which is used to update the add features
with their new feature IDs/primary keys. I'm not sure that's possible
using a COPY command.

View this message in context:
Sent from the QGIS - Developer mailing list archive at
QGIS-Developer mailing list
List info:

Reply via email to