qwat / qwat-data-model

TEKSI Water module (project QWAT) - PostgreSQL / postgis Datamodel
https://www.teksi.ch
23 stars 24 forks source link

add hardcoded _schema_visible field to pipes and valves for enhanced … #194

Closed 3nids closed 6 years ago

3nids commented 6 years ago

…perfomance on QGIS

This creates a field _schema_visible which determines if an element is visible in schematic view. It is calculated by COALESCE(schema_force_visible, value_list.schema_visible). This allows direct use of this field in QGIS for rule-based labeling and fixes performance issues if calculation is done on client side.

3nids commented 6 years ago

this does not provide very noticeable performance gain. But this fixes a few names of triggers and brings a useful field in the tables (pipe/valves). @haubourg @ponceta any concern to merge this?