Feature request #14364
Add an option to avoid querying data to collect extents
| Status: | Closed | ||
|---|---|---|---|
| Priority: | Normal | ||
| Assignee: | - | ||
| Category: | QGIS Server | ||
| Pull Request or Patch supplied: | No | Resolution: | fixed/implemented |
| Easy fix?: | No | Copied to github as #: | 22347 |
Description
QGIS server has severe overhead when initializing qgis project cache when getting extent of layers in a project when data are postgis views.
For big databases, this can be a real blocker (here 24s at first wms request, 7s for next queries.
This has been discussed here: performance questions
If this is possible with data providers, having an option in OWS project properties to ignore extent from data and trust project extent would be a great solution. This is how mapserver works I guess.
History
#1
Updated by aperi2007 - about 8 years ago
Just to explain how work mapserver:
The mapserver automatically retrieve the extend when it is not defined. To avoid this in mapserver is necessary to set the EXTENT parameter al layer level.
So the Mapserver avoid to calculate it.
Actually in the qgis is possible to set the EXTENT only at project level.
Perhaps an enhance could go in the direction to set manually the extent also at layer level.
My 2ct.
#2
Updated by Jürgen Fischer about 8 years ago
- Subject changed from [Server] add an option to avoid querying data to collect extents to [add an option to avoid querying data to collect extents
#3
Updated by Anita Graser about 8 years ago
- Subject changed from [add an option to avoid querying data to collect extents to Add an option to avoid querying data to collect extents
#4
Updated by Giovanni Manghi almost 7 years ago
- Easy fix? set to No
#5
Updated by Regis Haubourg almost 7 years ago
- Resolution set to fixed/implemented
- Description updated (diff)
- Status changed from Open to Closed
Done in QGIS 2.99, as a "trust" option for QGIS.