Re: [Qgis-user] QGIS freezes for minutes when updated SpatiaLite SQL Layer

2022-03-22 Thread SIGéal via Qgis-user
I created an issue : https://github.com/qgis/QGIS/issues/47906 I can reproduce it with a dead simple query : select * from table (returning ~ 800 rows). And no problem with any query/database on QGIS 3.16.16 ! Thanks, -- Christophe Le 22/03/2022 à 10:41, Alexandre Neto a écrit : It

Re: [Qgis-user] QGIS freezes for minutes when updated SpatiaLite SQL Layer

2022-03-22 Thread Alexandre Neto via Qgis-user
It probably also has something to do with the query you are using. Can you please create a ticket? Preferably with some sample data and project and explaining the steps to reproduce the problem. Thanks Alexandre Neto A terça, 22/03/2022, 09:24, SIGéal via Qgis-user escreveu: > Hi list, > >

[Qgis-user] QGIS freezes for minutes when updated SpatiaLite SQL Layer

2022-03-22 Thread SIGéal via Qgis-user
Hi list, QGIS 3.22/3.24 freezes with hourglass for about 2 minutes when I click on close button of Update SQL Layer dialog, even if I didn't modify the query. If I click on Execute button, I get this error : "an error occurred while opening GPKG dbname=..." This happens with a big database