Bug report #5523

Deleting columns from the Attribute Table - QGIS very slow

Added by Filipe Dias over 12 years ago. Updated over 12 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

Revision 7e692482
Added by Jürgen Fischer over 12 years ago

fix #5523

History

#1 Updated by Giovanni Manghi over 12 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 12 years ago

  • Category set to Vectors

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

#3 Updated by Giovanni Manghi over 12 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 12 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 12 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 12 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 12 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 12 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 12 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 12 years ago

Giovanni Manghi wrote:

With you dataset I can confirm

which dataset is that?

#12 Updated by Giovanni Manghi over 12 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 12 years ago

  • Status changed from Open to Closed

#14 Updated by Pieter Roggemans over 12 years ago

Thanks for the very quick reactions!!!

Also available in: Atom PDF