<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /></head><body style='font-size: 10pt; font-family: Verdana,Geneva,sans-serif'>
<p>It should be added here that QGIS (as a client) caches data in a local Geopackage (Even Rouault knows more about this). So the perfomance issue when consuming WFS isn't that bad.</p>
<p>On the other hand, I experienced bad user experience when using PostgreSQL/Postgis over slow network connections - the PostgreSQL data over the network isn't compressed/optimized and the latency can be substantial.</p>
<p>So there is not a clear and easy answer to your question.</p>
<p>If you have a lot of "relations" in your data, I would definitely do PostgreSQL with transaction mode (for editing in particular).</p>
<p>Andreas</p>
<p id="reply-intro">On 2021-01-07 10:53, Andrea Aime wrote:</p>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0">
<div id="replybody1">
<div>
<div dir="ltr">
<div dir="ltr">On Wed, Jan 6, 2021 at 5:16 PM Bernhard Ströbl <<a href="mailto:bernhard.stroebl@jena.de" rel="noreferrer">bernhard.stroebl@jena.de</a>> wrote:</div>
<div class="v1gmail_quote">
<blockquote class="v1gmail_quote" style="margin: 0px 0px 0px 0.8ex; border-left: 1px solid #cccccc; padding-left: 1ex;">Alessandro already. The data are in an XML format (GML) which is _slow_ <br />compared to data from a database</blockquote>
<div> </div>
<div>GML is the default format, but a WFS server can deliver other formats with better performance.</div>
<div>For example, GeoServer currently has a <a href="https://docs.geoserver.org/latest/en/user/community/flatgeobuf/installing.html" target="_blank" rel="noopener noreferrer">community module</a> that adds a <a href="https://github.com/flatgeobuf/flatgeobuf" target="_blank" rel="noopener noreferrer">FlatGeoBuf</a> WFS output format.</div>
<div>If QGIS could use it for reading*, then at least part of the performance issue could be solved.</div>
<div> </div>
<div>Cheers</div>
<div>Andrea</div>
<div> </div>
<div>*: this likely requires some development, but <a href="https://gdal.org/drivers/vector/flatgeobuf.html" target="_blank" rel="noopener noreferrer">GDAL/OGR has support for FlatGeoBuf</a>, so hopefully, not</div>
<div>too much extra effort.</div>
<div> </div>
</div>
<div class="v1gmail_signature" dir="ltr">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<p dir="ltr" style="line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;"><span style="font-family: Arial;"><span style="white-space: pre-wrap;">== GeoServer Professional Services from the experts! Visit <a href="http://goo.gl/it488V" target="_blank" rel="noopener noreferrer">http://goo.gl/it488V</a> for more information. == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via di Montramito 3/A 55054 Massarosa (LU) phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 <a href="http://www.geo-solutions.it" target="_blank" rel="noopener noreferrer">http://www.geo-solutions.it</a> <a href="http://twitter.com/geosolutions_it" target="_blank" rel="noopener noreferrer">http://twitter.com/geosolutions_it</a> ------------------------------------------------------- <em>Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati "GDPR"), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia. This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 "GDPR" - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail.</em><span style="font-size: 14.6667px;"> </span></span></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br />
<div class="pre" style="margin: 0; padding: 0; font-family: monospace">_______________________________________________<br />Qgis-user mailing list<br /><a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br />List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank" rel="noopener noreferrer">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br />Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank" rel="noopener noreferrer">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></div>
</blockquote>
<p><br /></p>
</body></html>