Bug report #21305

pasting features to postgis (or other slow/remote backends) is very slow

Added by Giovanni Manghi about 5 years ago. Updated about 5 years ago.

Status:Closed
Priority:High
Assignee:Alessandro Pasotti
Category:Vectors
Affected QGIS version:3.5(master) Regression?:Yes
Operating System: Easy fix?:No
Pull Request or Patch supplied:Yes Resolution:fixed/implemented
Crashes QGIS or corrupts data:No Copied to github as #:29123

Description

Pasting new features (copied from an identical layer) is unbearably slow, on QGIS 2.18 is done in very quick way (saving afterwards can be slow on both versions, depending on how many features were pasted).


Related issues

Duplicates QGIS Application - Bug report #21241: Copy/Paste between tables is much more slower compare to ... Open 2019-02-12

Associated revisions

Revision ba3d9ed0
Added by Alessandro Pasotti about 5 years ago

Cache unique values when creating features

Fixes #21305 - pasting features is very slow

Aggressively optimize createFeature for speed
and introduces createFeatures for bulk creation.

History

#1 Updated by Alessandro Pasotti about 5 years ago

  • Assignee set to Alessandro Pasotti

#2 Updated by Alessandro Pasotti about 5 years ago

  • Resolution set to fixed/implemented
  • Status changed from Open to In Progress
  • Pull Request or Patch supplied changed from No to Yes

#3 Updated by Giovanni Manghi about 5 years ago

Alessandro Pasotti wrote:

PR https://github.com/qgis/QGIS/pull/9203

Many thanks Ale for tackling this!

#4 Updated by Alessandro Pasotti about 5 years ago

  • Status changed from In Progress to Closed
  • % Done changed from 0 to 100

#5 Updated by Alessandro Pasotti about 5 years ago

  • Duplicates Bug report #21241: Copy/Paste between tables is much more slower compare to 2.18 added

#6 Updated by Alessandro Pasotti about 5 years ago

  • Subject changed from pasting features is very slow to pasting features to postgis is very slow

#7 Updated by Alessandro Pasotti about 5 years ago

  • Subject changed from pasting features to postgis is very slow to pasting features to postgis (or other slow/remote backends) is very slow

Also available in: Atom PDF