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 <cavall...@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@lists.osgeo.org > List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer >
_______________________________________________ Qgis-developer mailing list Qgis-developer@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer