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

[Paolo Cavallini]

Il 08/09/2016 17:01, Pietro Rossin ha scritto:

> By the way, 60MB are a huge amount of data compared to 30MB of the original
> shp.. Is that normal??
> 
> Other problem is that if I try to open the attribute table (dbf is 111KB)
> 30MB are downloaded more or less..
> 
> What could be the problem?

Have you imported it in single or double precision?
Do you have correct (minimal) data types for each column?
Could you simplify the data?
Have you checked disk speed?
All the best.
-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html