https://issues.qgis.org/https://issues.qgis.org/favicon.ico2019-01-20T23:35:15ZQGIS Issue TrackingQGIS Application - Bug report #20018: Server and desktop too slow with Postgis viewshttps://issues.qgis.org/issues/20018?journal_id=985202019-01-20T23:35:15ZJürgen Fischerjef@norbit.de
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Feedback</i></li></ul><p>Please test with QGIS 3.4 - QGIS 2.18 reached it's end of life.</p> QGIS Application - Bug report #20018: Server and desktop too slow with Postgis viewshttps://issues.qgis.org/issues/20018?journal_id=1012072019-03-04T13:40:10ZEvgeniy Baryshkove.baryshkov@gmail.com
<ul></ul><p>Jürgen Fischer wrote:</p>
<blockquote>
<p>Please test with QGIS 3.4 - QGIS 2.18 reached it's end of life.</p>
</blockquote>
<p>Same problem in QGIS 3.4.5 and 3.6</p> QGIS Application - Bug report #20018: Server and desktop too slow with Postgis viewshttps://issues.qgis.org/issues/20018?journal_id=1012092019-03-04T14:29:37ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Affected QGIS version</strong> changed from <i>2.18.23</i> to <i>3.4.5</i></li><li><strong>Status</strong> changed from <i>Feedback</i> to <i>Open</i></li></ul> QGIS Application - Bug report #20018: Server and desktop too slow with Postgis viewshttps://issues.qgis.org/issues/20018?journal_id=1048732019-05-23T18:59:44ZRegis Haubourgregis.haubourg@oslandia.com
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Feedback</i></li></ul><p>Can you try the "trust dataprovider" option that is in the project properties / data source ? That should speed up loading times a lot since this option skips those consuming queries for views and datasources that don't have those metadata (extent, geometry type, id). <br />?<br />In my cases, with 250 big views in a project, the opening time went from 1min30s down to 4s . That was made on purpose for QGIS server use cases.</p>