Bug report #5523

Deleting columns from the Attribute Table - QGIS very slow

Added by Filipe Dias over 8 years ago. Updated over 8 years ago.

Status:Closed
Priority:Normal
Assignee:-
Category:Vectors
Affected QGIS version:master Regression?:No
Operating System:Windows 7 Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:15121

Description

QGIS takes 5 minutes to delete 10 columns, while the Table Manager plugin does this in 5 seconds.

Associated revisions

History

#1 Updated by Giovanni Manghi over 8 years ago

it happens with all vectors? just shapefiles? also other datatypes (postgis, spatialite. etc.)? Eventually add sample data.

#2 Updated by Filipe Dias over 8 years ago

  • Category set to Vectors

Just shapefiles but I cant add the original data, since its confidential.

#3 Updated by Giovanni Manghi over 8 years ago

Filipe Dias wrote:

Just shapefiles but I cant add the original data, since its confidential.

so it happens just with a specific shapefile or it happens with any shapefile?

#4 Updated by Filipe Dias over 8 years ago

It happens with all shapefiles. The time that QGIS takes to delete a group columns increases exponentially with the number of selected columns.

#5 Updated by Giovanni Manghi over 8 years ago

Filipe Dias wrote:

It happens with all shapefiles. The time that QGIS takes to delete a group columns increases exponentially with the number of selected columns.

it can be a qgis problem, or not. Deleting columns from the vector properties uses OGR, while table manager doesn't. It would be needed to make a test using directly ogr and see if the behaviour is the same.

#6 Updated by Giovanni Manghi over 8 years ago

  • Status changed from Open to Feedback

I cannot confirm this, testing on qgis-dev, and a 240000 records table, after deleting 10 columns it took just a few seconds (after hitting "save" when toggling off editing). Can you please test with a different vector and/or on another machine?

#7 Updated by Giovanni Manghi over 8 years ago

With you dataset I can confirm the issue. On Windows especially it takes a lot of time after hitting the "save" button.

#8 Updated by Giovanni Manghi over 8 years ago

  • Subject changed from Deleting columns from the Attribute Table - QGIS takes more than 5 minutes to delete 10 fields to Deleting columns from the Attribute Table - QGIS very slow
  • Status changed from Feedback to Open

There are cases where it seems even to freeze.

#9 Updated by Pieter Roggemans over 8 years ago

Same here. Deleting colums takes minutes, first a progress bar per column, about a minute per column I think for a +- 130.000 shape, then when saving another minute...

#10 Updated by Jürgen Fischer over 8 years ago

Giovanni Manghi wrote:

With you dataset I can confirm

which dataset is that?

#12 Updated by Giovanni Manghi over 8 years ago

which dataset is that?

The original reported sent it to me privately but it is not possible to share it here, meanwhile the attached dataset should help anyway to replicate the issue.

#13 Updated by Jürgen Fischer over 8 years ago

  • Status changed from Open to Closed

#14 Updated by Pieter Roggemans over 8 years ago

Thanks for the very quick reactions!!!

Also available in: Atom PDF