<div dir="ltr">Hi,<div><br></div><div>We are getting the same experience as Manuel on 2.14.1 and we are using only standard relations.</div><div>Feature forms open instantly when not in edit mode and takes 10 seconds when edit mode is toggled on.</div><div><br></div><div>-Lauri</div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Apr 11, 2016 at 11:47 AM, Bernhard Ströbl <span dir="ltr"><<a href="mailto:bernhard.stroebl@jena.de" target="_blank">bernhard.stroebl@jena.de</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Manuel,<br>
<br>
instead of developping a new plugin my plugin DataDrivenInputMask [1] might suit your needs. It handles all kinds of relations and referential integrity out of the box (if thoroughly defined in the DB). Tickets, feedback, feature requests welcome.<br>
<br>
Bernhard<br>
<br>
[1] <a href="http://plugins.qgis.org/plugins/DataDrivenInputMask/" rel="noreferrer" target="_blank">http://plugins.qgis.org/plugins/DataDrivenInputMask/</a><span class=""><br>
<br>
<br>
Am 11.04.2016 um 10:30 schrieb Manuel Hernández Martínez:<br>
</span><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">
Hi, Andreas, thanks for your help.<br>
We tried the built-in relation support, combined with the edit widgets and form view. Is that what you mean? Powerful features as they are, they don’t fit our needs, however. There are quite a few tables, with two-level relationships; the generated forms and the workflow using the built-in solution is still too complex for our digitizers daily work. We also had doubts regarding to how to handle referential integrity constraints in edit mode. That’s why we finally decided to build our own plugin.<br>
In any case, I have taken a look at it again; it feels somewhat slower than our solution when not editing, and roughly the same in edit mode (no measures, though, just my first subjective impressions).<br>
<br>
De: Neumann, Andreas [mailto:<a href="mailto:a.neumann@carto.net" target="_blank">a.neumann@carto.net</a>]<br>
Enviado el: viernes, 08 de abril de 2016 16:02<br>
Para: Manuel Hernández Martínez<br>
CC: '<a href="mailto:qgis-developer@lists.osgeo.org" target="_blank">qgis-developer@lists.osgeo.org</a>'<br>
Asunto: Re: [Qgis-developer] PostGIS queries slow when in edit mode<br>
<br>
<br>
Hi Manuel,<br>
<br>
QGIS already has built-in relation support (1:n and n:m) - they should support server side queries. Do you really need to write your own plugin? Are the built-in relations not good enough?<br>
<br>
Andreas<br>
<br>
On 2016-04-08 15:26, Manuel Hernández Martínez wrote:<br>
Hi!<br>
I'm developing a plugin for QGIS. When the user selects a feature, it queries a few other layers from Postgis to fill in a form with related data.<br>
The queries are slow, unless I check the option to run queries server-side. After that, the queries run instantaneously. Yay!<br>
However, if the layers are put in edit mode, the queries are slow again! :(<br>
After checking the Postgis logs it seems that the run queries server-side option has no effect when the layers are in edit mode.<br>
Does anyone know whether it is a known, well-founded limitation or a bug?<br>
<br>
Regards, Manuel<br>
<br>
________________________________<br>
Manuel Hernández Martínez<br>
</span><a href="mailto:mhernandezm@agenciamedioambienteyagua.es" target="_blank">mhernandezm@agenciamedioambienteyagua.es</a><mailto:<a href="mailto:mhernandezm@agenciamedioambienteyagua.es" target="_blank">mhernandezm@agenciamedioambienteyagua.es</a>><span class=""><br>
<br>
Agencia de Medio Ambiente y Agua de Andalucía.<br>
</span><a href="http://www.agenciamedioambienteyagua.es" rel="noreferrer" target="_blank">http://www.agenciamedioambienteyagua.es</a><<a href="http://www.agenciamedioambienteyagua.es/" rel="noreferrer" target="_blank">http://www.agenciamedioambienteyagua.es/</a>><span class=""><br>
Subdirección de Tecnologías de la Información.<br>
Red de Información Ambiental de Andalucía, REDIAM.<br>
<br>
Johan G. Gutenberg, 1. Isla de la Cartuja<br>
<br>
41092 - SEVILLA, Sevilla. (Spain)<br>
<br>
<br>
<br>
Tel:<br>
<br>
<a href="tel:%2B34%20955%2026%2000%2000" value="+34955260000" target="_blank">+34 955 26 00 00</a> / <a href="tel:%2B34%20902%2052%2051%2000" value="+34902525100" target="_blank">+34 902 52 51 00</a><br>
<br>
Fax:<br>
<br>
<a href="tel:%2B34%20955%2004%2046%2010" value="+34955044610" target="_blank">+34 955 04 46 10</a><br>
<br>
<br>
<br>
<br>
<br>
En la medida de lo posible, evite imprimir este correo.<br>
<br>
Este correo electrónico y los documentos que en él se puedan adjuntar, contiene información de carácter confidencial dirigida exclusivamente a su/s destinatario/s. Si Usted no es el destinatario de este mensaje, le ruego que lo destruya sin hacer copia digital o física, comunicando por correo electrónico, fax o teléfono a la Agencia de Medio Ambiente y Agua de Andalucía la recepción del mismo. Así mismo, queda expresamente prohibida su divulgación, copia o distribución a terceros sin la previa autorización escrita de la Agencia de Medio Ambiente y Agua de Andalucía.<br>
<br>
<br>
<br>
<br>
_______________________________________________<br>
Qgis-developer mailing list<br>
</span><a href="mailto:Qgis-developer@lists.osgeo.org" target="_blank">Qgis-developer@lists.osgeo.org</a><mailto:<a href="mailto:Qgis-developer@lists.osgeo.org" target="_blank">Qgis-developer@lists.osgeo.org</a>><span class=""><br>
List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
<br>
<br>
<br>
<br>
<br></span><span class="">
Hi, Andreas, thanks for your help.<br>
<br>
We tried the built-in relation support, combined with the edit widgets<br>
and form view. Is that what you mean? Powerful features as they are,<br>
they don’t fit our needs, however. There are quite a few tables, with<br>
two-level relationships; the generated forms and the workflow using the<br>
built-in solution is still too complex for our digitizers daily work. We<br>
also had doubts regarding to how to handle referential integrity<br>
constraints in edit mode. That’s why we finally decided to build our own<br>
plugin.<br>
<br>
In any case, I have taken a look at it again; it feels somewhat slower<br>
than our solution when not editing, and roughly the same in edit mode<br>
(no measures, though, just my first subjective impressions).<br>
<br></span>
*De:*Neumann, Andreas [mailto:<a href="mailto:a.neumann@carto.net" target="_blank">a.neumann@carto.net</a>]<br>
*Enviado el:* viernes, 08 de abril de 2016 16:02<br>
*Para:* Manuel Hernández Martínez<br>
*CC:* '<a href="mailto:qgis-developer@lists.osgeo.org" target="_blank">qgis-developer@lists.osgeo.org</a>'<br>
*Asunto:* Re: [Qgis-developer] PostGIS queries slow when in edit mode<span class=""><br>
<br>
Hi Manuel,<br>
<br>
QGIS already has built-in relation support (1:n and n:m) - they should<br>
support server side queries. Do you really need to write your own<br>
plugin? Are the built-in relations not good enough?<br>
<br>
Andreas<br>
<br>
On 2016-04-08 15:26, Manuel Hernández Martínez wrote:<br>
<br>
Hi!<br>
<br>
I'm developing a plugin for QGIS. When the user selects a feature,<br>
it queries a few other layers from Postgis to fill in a form with<br>
related data.<br>
<br>
The queries are slow, unless I check the option to run queries<br>
server-side. After that, the queries run instantaneously. Yay!<br>
<br>
However, if the layers are put in edit mode, the queries are slow<br>
again! :(<br>
<br>
After checking the Postgis logs it seems that the run queries<br>
server-side option has no effect when the layers are in edit mode.<br>
<br>
Does anyone know whether it is a known, well-founded limitation or a<br>
bug?<br>
<br>
Regards, Manuel<br>
<br></span>
------------------------------------------------------------------------<br>
<br>
*Manuel Hernández Martínez*<br>
<br>
<a href="mailto:mhernandezm@agenciamedioambienteyagua.es" target="_blank">mhernandezm@agenciamedioambienteyagua.es</a><br>
<mailto:<a href="mailto:mhernandezm@agenciamedioambienteyagua.es" target="_blank">mhernandezm@agenciamedioambienteyagua.es</a>><span class=""><br>
<br>
Agencia de Medio Ambiente y Agua de Andalucía.<br>
<br>
<a href="http://www.agenciamedioambienteyagua.es" rel="noreferrer" target="_blank">http://www.agenciamedioambienteyagua.es</a><br></span>
<<a href="http://www.agenciamedioambienteyagua.es/" rel="noreferrer" target="_blank">http://www.agenciamedioambienteyagua.es/</a>><span class=""><br>
<br>
Subdirección de Tecnologías de la Información.<br>
<br>
Red de Información Ambiental de Andalucía, REDIAM.<br>
<br>
Johan G. Gutenberg, 1. Isla de la Cartuja<br>
<br>
41092 - SEVILLA, Sevilla. (Spain)<br>
<br>
Tel:<br>
<br>
<br>
<br>
<a href="tel:%2B34%20955%2026%2000%2000" value="+34955260000" target="_blank">+34 955 26 00 00</a> / <a href="tel:%2B34%20902%2052%2051%2000" value="+34902525100" target="_blank">+34 902 52 51 00</a><br>
<br>
Fax:<br>
<br>
<br>
<br>
<a href="tel:%2B34%20955%2004%2046%2010" value="+34955044610" target="_blank">+34 955 04 46 10</a><br>
<br>
<br>
<br></span>
*En la medida de lo posible, evite imprimir este correo. *<span class=""><br>
<br>
Este correo electrónico y los documentos que en él se puedan<br>
adjuntar, contiene información de carácter confidencial dirigida<br>
exclusivamente a su/s destinatario/s. Si Usted no es el destinatario<br>
de este mensaje, le ruego que lo destruya sin hacer copia digital o<br>
física, comunicando por correo electrónico, fax o teléfono a la<br>
Agencia de Medio Ambiente y Agua de Andalucía la recepción del<br>
mismo. Así mismo, queda expresamente prohibida su divulgación, copia<br>
o distribución a terceros sin la previa autorización escrita de la<br>
Agencia de Medio Ambiente y Agua de Andalucía.<br>
<br>
_______________________________________________<br>
Qgis-developer mailing list<br></span>
<a href="mailto:Qgis-developer@lists.osgeo.org" target="_blank">Qgis-developer@lists.osgeo.org</a> <mailto:<a href="mailto:Qgis-developer@lists.osgeo.org" target="_blank">Qgis-developer@lists.osgeo.org</a>><span class=""><br>
List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
<br>
<br>
<br>
_______________________________________________<br>
Qgis-developer mailing list<br>
<a href="mailto:Qgis-developer@lists.osgeo.org" target="_blank">Qgis-developer@lists.osgeo.org</a><br>
List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
<br>
</span></blockquote>
<br>
<br>
__________ Information from ESET Mail Security, version of virus signature database 13315 (20160411) __________<br>
<br>
The message was checked by ESET Mail Security.<br>
<a href="http://www.eset.com" rel="noreferrer" target="_blank">http://www.eset.com</a><div class="HOEnZb"><div class="h5"><br>
<br>
<br>
_______________________________________________<br>
Qgis-developer mailing list<br>
<a href="mailto:Qgis-developer@lists.osgeo.org" target="_blank">Qgis-developer@lists.osgeo.org</a><br>
List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a></div></div></blockquote></div><br></div>