[Qgis-user] Best practice, database vs WFS
Andreas Neumann
a.neumann at carto.net
Thu Jan 7 02:11:07 PST 2021
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>
More information about the Qgis-user
mailing list