Hi,
El 21/06/16 a las 10:35, Richard McDonnell escribió: > Hi Daniel, > Ok, so the first thing I would ask, is have you Indexed the geometry? yes > Secondly, If you are using any of the attributes for styling, I would > also advise using Indexing on those also. Not used in the testing data, but I'll take note of this for other situations. > Thirdly Zoom Levels, do you need to show all the data when zoomed out > fully? If not, you can create zoom levels in your styling which can > minimise the amount of geometry shown, speeding up draw time. Ok, I didn't even dare zooming (in or out), but the default extent is a zoomed in portion of the "big" layer (~1/15 of the total surface). I'll check this. Thanks > Hope this helps, > Regards, > > Richard. > > > > On 21/06/2016 15:29, Daniel Vicente Lühr Sierra wrote: >> >> Hi, >> >> It is my first time at setting up a postgres/PostGIS db for storing >> "serious" data (previously, I had only tested if it worked, with a >> couple of small data tables). >> >> When testing the web-client (lizmap) installation I noticed that the >> sample data loaded pretty fast, but when I tried a project containing >> 2 vector layers stored in the database, one very small, the second >> one was originally a ~30Mb shape file, the loading process for the 2 >> layers is noticeable, and reading the attribute table of the big >> vector layer (only 20 rows and 10 fields) takes ages (actually, I >> wasn't able to wait for it to load). >> >> I did some "google" research and found out that there might be some >> performance issues on qgis-server when accessing postgresql layer, or >> it could be that the performance of the db is low (I haven't run the >> tuning utility, yet). >> >> Any ideas on how to hunt down this performance issue? May it be an >> issue with the web-client, also? >> >> Btw, everything is running locally on a VM for now, although the >> final deployment will be on "real" hardware. >> >> Thanks >> -- >> Daniel Vicente Lühr Sierra >> IEEE Member >> IEEE Student Branch Counselor - Universidad Austral de Chile >> >> >> >> _______________________________________________ >> Qgis-user mailing list >> [email protected] >> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user >> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user > > -- > *_Richard McDonnell_* > *GIS Specialist PgD GIS AssocSCSI* > *OPW FRM Data Management* > *52 Stephens Green, Dublin 2.* > TEL: 01 6476543 > OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart > OPW - Looking to the future - Caring for the past > <http://www.opw.ie/> > Email Disclaimer: http://www.opw.ie/en/disclaimer/ -- Daniel Vicente Lühr Sierra IEEE Member IEEE Student Branch Counselor - Universidad Austral de Chile
_______________________________________________ Qgis-user mailing list [email protected] List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
