to be clear, PostGIS layers added using the option “select at id” , and then saved within a QGIS XML project file, will load from that project file very fast from then on?
Can I distribute project files with this option embedded in it, so that I might “suffer for the sake of others” and they have a pleasant experience seeing what I have authored? thank you Chris Nicholas > On Nov 15, 2016, at 3:26 AM, Giovanni Manghi <[email protected]> > wrote: > > Hi, > >> Could you check if an issue mentioning this problem exists already >> on hub.qgis.org and add one if not already present ? >> >> I've had the same impression and it is possible this was a regression. >> It'd be great to have an automated test guarding against full table >> scans with PostGIS, to secure the feature once for all.. > > > this is my observation on 2.14.8: > > if the postgis layer is added (via the "add postgis layer" dialog) > with the "select at id" checkbox then when opening the attribute table > this is iterated one time. If the table is large browsing it is not > very snappy. > > If the layer is added without the "select at id" thing, then the table > is always iterated twice before opening. If the "show features visible > on map" option is selected, the table is still iterated twice (the > entire table, not only the records of visible features) before > opening. Browsing of large tables (once opened) is fast. > > One ticket I found that may be related > > http://hub.qgis.org/issues/10619 > > > cheers > > -- G -- > _______________________________________________ > Qgis-developer mailing list > [email protected] > List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer
signature.asc
Description: Message signed with OpenPGP using GPGMail
_______________________________________________ Qgis-developer mailing list [email protected] List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer
