Friday 29 June 2018

QGIS MySql database queries over 4000


When i open file of QGIS 2.6.1 with 32 layers whose tables all come from the same database, i see that by just opening the file, QGIS already sends 4100+ "SELECT..."-questions to the database, and around 2000 "DESCRIBE..."-questions.


The interaction with QGIS becomes very slow this way. Any idea which settings might cause this or is this by defaut?



I have pasted the SERVERLOGS on pastebin and what i see is a lot of queries like:


SELECT srid FROM geometry_columns WHERE f_table_name = 'vegetation'


http://pastebin.com/pKSgK99y


I do not have any of these columns, no "srid", no "geometry_columns", no "f_table_name" defined in my database. Should these be in database? (the qgis-database works, but very slow)




No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...