[Qgis-user] Best practice, database vs WFS

[Andreas Neumann]

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.

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.

So there is not a clear and easy answer to your question.

If you have a lot of "relations" in your data, I would definitely do 
PostgreSQL with transaction mode (for editing in particular).

Andreas

On 2021-01-07 10:53, Andrea Aime wrote:

> On Wed, Jan 6, 2021 at 5:16 PM Bernhard Ströbl 
> <bernhard.stroebl at jena.de> wrote:
> 
>> Alessandro already. The data are in an XML format (GML) which is 
>> _slow_
>> compared to data from a database
> 
> GML is the default format, but a WFS server can deliver other formats 
> with better performance.
> For example, GeoServer currently has a community module [1] that adds a 
> FlatGeoBuf [2] WFS output format.
> If QGIS could use it for reading*, then at least part of the 
> performance issue could be solved.
> 
> Cheers
> Andrea
> 
> *: this likely requires some development, but GDAL/OGR has support for 
> FlatGeoBuf [3], so hopefully, not
> too much extra effort.
> 
> == GeoServer Professional Services from the experts! Visit 
> http://goo.gl/it488V 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 http://www.geo-solutions.it 
> http://twitter.com/geosolutions_it 
> ------------------------------------------------------- _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._
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user



Links:
------
[1] 
https://docs.geoserver.org/latest/en/user/community/flatgeobuf/installing.html
[2] https://github.com/flatgeobuf/flatgeobuf
[3] https://gdal.org/drivers/vector/flatgeobuf.html
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20210107/6cbdd759/attachment.html>