QGIS eats too much data with relation reference widget

[qgib]

Author Name: Regis Haubourg (@haubourg)
Original Redmine Issue: 17502
Affected QGIS version: 2.18.14
Redmine category:edit_widget
Assignee: Hugo Mercier

---

When using large databases in QGIS 2.18.14, I discovered QGIS was fetching 3 times the referenced table objects.

How to reproduce:

• create a DB with two tables, on reference table and one referencing with a FK pointing to the reference table.

• configure the relation in QGIS and add a relation reference widget on the FK field

(use only one readonly line and point on map tool activated)

• create a referencing object > its fast

• reopen the object form > it's slow and querying three times the reference dataset, including all fields when only id, geom and tooltip fields should be necessary.

Anyway, for QGIS 3 fixing that will not solve totally the real issue that is that loading all the reference layer is overkill. asynchroneous loading is being made by Matthias in QGIS 3, but only loading in the current extent, and only fetching the required fields (id, geom, PK, display expression result) would be very nice.

---

• PG_LOG (Regis Haubourg)

[qgib]

Author Name: Hugo Mercier (@mhugo)

---

Applied in changeset 5fb970a.

---

• done_ratio was changed from 0 to 100
• status_id was changed from Open to Closed