https://issues.qgis.org/https://issues.qgis.org/favicon.ico2015-12-23T04:22:18ZQGIS Issue TrackingQGIS Application - Bug report #14030: Filter expressions to postgres providerhttps://issues.qgis.org/issues/14030?journal_id=667022015-12-23T04:22:18ZMatthias Kuhn
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Feedback</i></li></ul><p>Which expression?</p> QGIS Application - Bug report #14030: Filter expressions to postgres providerhttps://issues.qgis.org/issues/14030?journal_id=667062015-12-23T06:23:24ZEdward Hedouard.hyvernat@gmail.com
<ul></ul><p>In fact, on my map canvas, i use the button "Identify Features" to visualize some datas edited with the "drag and drop designer". And the result is a combinaison of "LEFT JOIN".</p>
<p>Without the check of "Execute expressions on postgres server side if possible" the result is very slow, but fast with this option enable. <br />Now, check or not check (in QGIS Master), the result is very slow.</p>
<p>Sorry if this description is not very understandable.</p> QGIS Application - Bug report #14030: Filter expressions to postgres providerhttps://issues.qgis.org/issues/14030?journal_id=667182015-12-24T04:29:19ZMatthias Kuhn
<ul></ul><p>I think that the forms with relations were never actually using the expression compiler IIRC.</p> QGIS Application - Bug report #14030: Filter expressions to postgres providerhttps://issues.qgis.org/issues/14030?journal_id=669832016-01-07T00:48:21ZEdward Hedouard.hyvernat@gmail.com
<ul><li><strong>File</strong> <a href="/attachments/download/9445/Relations2.png">Relations2.png</a> added</li><li><strong>File</strong> <a href="/attachments/download/9444/Relations1.png">Relations1.png</a> added</li></ul><p>Hi, sorry for the long time to respond.<br />I will try to be more explicit about this issue :</p>
<p>I load 2 "big" tables in QGIS master and QGIS 2.12 = table one (461010 rows) / table two (415130 rows)</p>
<p>I join these tables with the project Properties > Relations (look picture "Relations1")</p>
<p>"Execute expressions on server side" is enable for the two projects<br />I use the button "Identify Features" to visualize an object (there is a french cadastral plot)<br />Less than 2 seconds for QGIS 2.12 / More than 1 minute for QGIS master (look picture "Relations2")</p>
<p>IF I disable "Execute expressions on server side" in QGIS 2.12, there is like QGIS master, more than 1 minute to display the form with the "Identify Features" button</p>
<p>So I thought that the expression compiler is linked to the forms with relations...</p>
<p>This issue may be replicate easily with 2 big tables.<br />Thank you if you can watch this issue</p> QGIS Application - Bug report #14030: Filter expressions to postgres providerhttps://issues.qgis.org/issues/14030?journal_id=669852016-01-07T02:45:37ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Status</strong> changed from <i>Feedback</i> to <i>Open</i></li></ul> QGIS Application - Bug report #14030: Filter expressions to postgres providerhttps://issues.qgis.org/issues/14030?journal_id=670832016-01-12T08:11:48ZEdward Hedouard.hyvernat@gmail.com
<ul><li><strong>File</strong> <a href="/attachments/download/9465/Issue_Large_Relationship_Tables.JPG">Issue_Large_Relationship_Tables.JPG</a> added</li><li><strong>Assignee</strong> changed from <i>Jürgen Fischer</i> to <i>Matthias Kuhn</i></li></ul><p>@Matthias Kuhn,</p>
<p>I found this post on the blog <a class="external" href="http://blog.vitu.ch/10112013-1201/qgis-relations">http://blog.vitu.ch/10112013-1201/qgis-relations</a> that explains the role of the "server-side index" with an answer from you.<br />I have the same problem as mentionned in this post : I tried to build a relationship between PostgreSQL tables where the related table has about half million rows<br />When these relations works perfectly in QGIS 2.12 (with the option "Execute expressions on server side" enable), it does not work in qgis master...<br />Thank you again if you can have a look at my problem and I hope what i'm seeing make sense</p> QGIS Application - Bug report #14030: Filter expressions to postgres providerhttps://issues.qgis.org/issues/14030?journal_id=673372016-01-18T12:23:52ZNyall Dawson
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Feedback</i></li></ul><p>Please test with tomorrow's nightlies - likely fixed with ed54e3cc0be4b9a79ac23adf8bffc858d315c01e</p> QGIS Application - Bug report #14030: Filter expressions to postgres providerhttps://issues.qgis.org/issues/14030?journal_id=673562016-01-19T00:24:37ZEdward Hedouard.hyvernat@gmail.com
<ul></ul><p>OK, thanks a lot. I will test with the next QGIS nightly build and then close this issue.</p> QGIS Application - Bug report #14030: Filter expressions to postgres providerhttps://issues.qgis.org/issues/14030?journal_id=675072016-01-21T00:22:24ZEdward Hedouard.hyvernat@gmail.com
<ul><li><strong>Status</strong> changed from <i>Feedback</i> to <i>Closed</i></li></ul><p>perfect ! it works very well</p>