Re: [Qgis-user] Adding layer slows down QGIS dramatically after adding a layer
Hi Peter, One further thing you could try, if not already done, is to create Spatial Index’s. You can do this within QGIS under the Layer Properties, by going to the Source tab and selecting, Create Spatial Index. See: https://medium.com/@wherelytics/understanding-spatial-indexes-in-ogc-geopackage-files-9960fdf71f82 Hope this helps Richard. —— Richard McDonnell MSc GIS, FME Certified Professional FRM Data Management —— Oifig na nOibreacha Poiblí Office of Public Works Sráid Jonathan Swift, Baile Átha Troim, Co na Mí, C15 NX36 Jonathan Swift Street, Trim, Co Meath, C15 NX36 —— M +353 87 688 5964 T +353 1 647 6543 https://www.opw.ie —— To send me files larger than 30MB, please use the link below https://filetransfer.opw.ie/filedrop/richard.mcdonn...@opw.ie Email Disclaimer: https://www.opw.ie/en/disclaimer/ From: Qgis-user On Behalf Of Peter Cornelissen Sent: 14 August 2020 00:19 To: rdmaili...@duif.net Cc: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Adding layer slows down QGIS dramatically after adding a layer Hi Richard Thanks for the suggestion. They are plain filters and I tried indexing every table, but unfortunately it has made no noticeable difference. Regards, Peter On Thu, 13 Aug 2020 at 15:35, Richard Duivenvoorde mailto:rdmaili...@duif.net>> wrote: On 8/13/20 3:57 PM, Peter Cornelissen wrote: > Hi > > I am using a Geopackage with about 15 tables (a mixture of lines, polygons > and points), but each of these tables are > used 40 or 50 times with filters as many of the elements are used on multiple > layers. > However, I am now finding that as soon as I add a new layer QGIS slows down > and it is taking 60 seconds or more to do almost any action that involves > redrawing (zoom in/out/ pan etc) or even moving a layer within the layers > panel. If I save the project, close down QGIS and restart, it is fine again > until the next time. > > Any suggestions? > > Thanks, Peter Looking at the attributes which are used in the filters, add 'indexes' too the tables in the Geopackage? In QGIS you can do that by creating a connection to the gpkg with DataBase Manager and then: 'edit table' > tab indexes, > add index A geopackage is a sqlite database, so if you have some sql-client (DB-manager, DB-browser) you can fire the create index query there: CREATE INDEX "foo_index" ON "mygeopackage" ("foo_column") Note that these are plain indexes, no spatial ones. IF your filters are spatial filters, then off course you need spatial indexes. HTH Regards, Richard Duivenvoorde ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Adding layer slows down QGIS dramatically after adding a layer
On Fri, 14 Aug 2020 at 00:06, Peter Cornelissen wrote: > > Hi > > I am using a Geopackage with about 15 tables (a mixture of lines, polygons > and points), but each of these tables are > used 40 or 50 times with filters as many of the elements are used on multiple > layers. > However, I am now finding that as soon as I add a new layer QGIS slows down > and it is taking 60 seconds or more to do almost any action that involves > redrawing (zoom in/out/ pan etc) or even moving a layer within the layers > panel. If I save the project, close down QGIS and restart, it is fine again > until the next time. Sounds very much like a faulty plugin is installed. Try starting QGIS from a clean profile and see if it resolves the issue. Nyall > > Any suggestions? > > Thanks, Peter > > ___ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Adding layer slows down QGIS dramatically after adding a layer
Hi Richard Thanks for the suggestion. They are plain filters and I tried indexing every table, but unfortunately it has made no noticeable difference. Regards, Peter On Thu, 13 Aug 2020 at 15:35, Richard Duivenvoorde wrote: > On 8/13/20 3:57 PM, Peter Cornelissen wrote: > > Hi > > > > I am using a Geopackage with about 15 tables (a mixture of lines, > polygons and points), but each of these tables are > > used 40 or 50 times with filters as many of the elements are used on > multiple layers. > > However, I am now finding that as soon as I add a new layer QGIS slows > down > > and it is taking 60 seconds or more to do almost any action that involves > > redrawing (zoom in/out/ pan etc) or even moving a layer within the layers > > panel. If I save the project, close down QGIS and restart, it is fine > again > > until the next time. > > > > Any suggestions? > > > > Thanks, Peter > > Looking at the attributes which are used in the filters, add 'indexes' too > the tables in the Geopackage? > > In QGIS you can do that by creating a connection to the gpkg with DataBase > Manager and then: > 'edit table' > tab indexes, > add index > > A geopackage is a sqlite database, so if you have some sql-client > (DB-manager, DB-browser) you can fire the create index query there: > CREATE INDEX "foo_index" ON "mygeopackage" ("foo_column") > > Note that these are plain indexes, no spatial ones. > IF your filters are spatial filters, then off course you need spatial > indexes. > > HTH > > Regards, > > Richard Duivenvoorde > ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Adding layer slows down QGIS dramatically after adding a layer
On 8/13/20 3:57 PM, Peter Cornelissen wrote: > Hi > > I am using a Geopackage with about 15 tables (a mixture of lines, polygons > and points), but each of these tables are > used 40 or 50 times with filters as many of the elements are used on multiple > layers. > However, I am now finding that as soon as I add a new layer QGIS slows down > and it is taking 60 seconds or more to do almost any action that involves > redrawing (zoom in/out/ pan etc) or even moving a layer within the layers > panel. If I save the project, close down QGIS and restart, it is fine again > until the next time. > > Any suggestions? > > Thanks, Peter Looking at the attributes which are used in the filters, add 'indexes' too the tables in the Geopackage? In QGIS you can do that by creating a connection to the gpkg with DataBase Manager and then: 'edit table' > tab indexes, > add index A geopackage is a sqlite database, so if you have some sql-client (DB-manager, DB-browser) you can fire the create index query there: CREATE INDEX "foo_index" ON "mygeopackage" ("foo_column") Note that these are plain indexes, no spatial ones. IF your filters are spatial filters, then off course you need spatial indexes. HTH Regards, Richard Duivenvoorde ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Adding layer slows down QGIS dramatically after adding a layer
Hi I am using a Geopackage with about 15 tables (a mixture of lines, polygons and points), but each of these tables are used 40 or 50 times with filters as many of the elements are used on multiple layers. However, I am now finding that as soon as I add a new layer QGIS slows down and it is taking 60 seconds or more to do almost any action that involves redrawing (zoom in/out/ pan etc) or even moving a layer within the layers panel. If I save the project, close down QGIS and restart, it is fine again until the next time. Any suggestions? Thanks, Peter ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user