[Qgis-developer] Qgis and huge amount of data opening "small" postgis layer

[kimaidou]

Hi,

Have you checked in the tab "Rendering" of your layer properties the
checkbox about "Realize simplification by the provider if possible" (or a
text similar, as I just translated from french...).
It can make a huge difference for smal scales like 1:500000, because data
is simplified server-side and then downloaded.See:
https://github.com/qgis/QGIS/pull/2410#issuecomment-160987344

Regards
Michaël

2016-09-08 17:12 GMT+02:00 Paolo Cavallini <cavallini at faunalia.it>:

> Il 08/09/2016 17:09, Pietro Rossin ha scritto:
> > Thanks Paolo
> >
> > This is the table:
> >
> > CREATE mytable_3045
> > (
> >   id serial NOT NULL,
> >   geom geometry(MultiPolygonZ,3045),
> >   nome character varying(255),
> >   cod_istat character varying(255),
> >   CONSTRAINT mytable_3045_pkey PRIMARY KEY (id)
> > )
> > WITH (
> >   OIDS=FALSE
> > );
>
> Certainly varchar can be smaller, this would save ome byte, but I'd not
> expect dramatic improvements. Why geomZ?
> Is the geom in single or double precision?
> All the best.
> --
> Paolo Cavallini - www.faunalia.eu
> QGIS & PostGIS courses: http://www.faunalia.eu/training.html
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20160908/7374f4db/attachment.html>