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
[Qgis-user] DB Browser connection via Spatialite
Excited to learn via this excellent tutorial [1] that i can connect my favorite SQL tool (DB Browser for SQLite) to the .gpkg files that i am just starting to build w/ QGIS, i gave it a try straight away and found that it does indeed recognize my .gpkg file as a readable database, such that i can explore the db structure and browse tables data -- Except for the "geom" column, which just has "blob" in every field (first clue it's not so simple!). Then i tried to make a small edit to one field of non-geographic data... And that made a mess of everything so i had to delete the layer and start over. So i wonder: maybe QGIS doesn't allow any other app to edit data in its .gpkg files? Reading deeper into tutorial [1], it seems that DB Browser needs a spatialite extension (mod_spatialite.dylib for Mac 64), which good folks at Fulcrum have kindly provided via their Github repo [2]... But following dead-simple instructions given in tutorial [1], my installation fails with the error msg: > Error loading extension: > dlopen(/Users/walterludwick/Desktop/mod_spatialite.dylib.dyylib, 10): image > not found (Strange: that redundant .dylib extension is not in the filepath i chose, but... So it goes) Anyway: i know this isn't the forum for DB Browser support, but because it is so widely adopted in QGIS (and FOSS more generally) world, i just wonder if anyone here is using it, and if so might be able to shed any light on this problem. ? NOTES: [1] Tutorial: https://www.fulcrumapp.com/blog/working-with-geodata/ [2] Spatialite for DB Browser: https://github.com/fulcrumapp/spatialite-bin ___ 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