Hi all,
I'm facing very slow opening of project files for a customer here in QGIS
3.4.5. Something like 7 minutes, against 30 s in QGIS 2.18.

We are still investigating to narrow it down, but I faced a first query in
the logs that I fail to understand.

QGIS emits this at a point:

select count(*)

from information_schema.tables

where table_name = 'qgis_editor_widget_styles' ;

And this query is long in our context, 1.7s, because of a very high number
of tables and schemas in that production DB.

I found at [0] in the postgres provider where it comes from, I found the
associated PR [1], but I fail to understand in what workflow this table is
created using QGIS, and what it is used for.

Can someone put some light here ?

Best regards

Régis

[0]
https://github.com/qgis/QGIS/blob/master/src/providers/postgres/qgspostgresprovider.cpp#L1083
[1] https://github.com/qgis/QGIS/pull/3439
_______________________________________________
QGIS-Developer mailing list
[email protected]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Reply via email to