Deleting columns from the Attribute Table - QGIS very slow

[qgib]

Author Name: Filipe Dias (@fsdias)
Original Redmine Issue: 5523
Affected QGIS version: master
Redmine category:vectors

---

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

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

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

[qgib]

Author Name: Filipe Dias (@fsdias)

---

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

---

• category_id was configured as Vectors

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

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?

[qgib]

Author Name: Filipe Dias (@fsdias)

---

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

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

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.

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

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?

---

• status_id was changed from Open to Feedback

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

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

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

There are cases where it seems even to freeze.

---

• subject was 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_id was changed from Feedback to Open

[qgib]

Author Name: Pieter Roggemans (@theroggy)

---

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...

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

Giovanni Manghi wrote:

With you dataset I can confirm

which dataset is that?

[qgib]

Author Name: Pieter Roggemans (@theroggy)

---

Example file can be found here:
https://docs.google.com/open?id=0B-lmgiUm-f0HRWpadzZpNlk4cmM

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

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.

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

Fixed in changeset "7e6924820dd5c3f30c2f03ee7c9319c45476b905".

---

• status_id was changed from Open to Closed

[qgib]

Author Name: Pieter Roggemans (@theroggy)

---

Thanks for the very quick reactions!!!