Thanks Bo , It seems to be a valid workaround for us. I'm interesting in such procedure.
Thanks for your help [cid:image001.jpg@01D7AEEF.96D57FB0] Sylvain PIERRE Chef de projet système d'information Direction des Systèmes d'Information et du Développement Numérique Service Projets et Ingénierie Numérique Collectivité européenne d'Alsace Tél : 03 88 76 68 88 sylvain.pie...@alsace.eu<mailto:sylvain.pie...@alsace.eu> www.alsace.eu<http://www.alsace.eu> [facebook]<http://www.facebook.com/toutelalsace> [twitter] <http://www.twitter.com/toutelalsace> [insta] <http://www.instagram.com/toutelalsace> De : QGIS-Developer <qgis-developer-boun...@lists.osgeo.org> De la part de Bo Victor Thomsen Envoyé : mardi 21 septembre 2021 09:04 À : qgis-developer@lists.osgeo.org Objet : Re: [QGIS-Developer] QGIS connections to MSSQL generate multiple (000s) processes on database server >From the bug report: "QGIS is operating a 'full table scan' for MSSQL connections where no geometry_columns table exists." which triggers the situation. That's not smart and should be fixed. However until that happens, an obvious work-around would be to create and populate a geometry_columns table. So if you don't have a geometry_columns table in the database, create one and populate it with the information about your spatial tables. This can be done automatically with a stored procedure outside the scope of QGIS. I think I have such procedure lurking somewhere in my dungeon of a backup system. Send me a mail if you're interested. Med venlig hilsen / Kind regards Bo Victor Thomsen Den 20-09-2021 kl. 11:44 skrev PIERRE Sylvain: Hi , In want to connect with QGIS to a MSSQL geodabase. But when connecting to this DB it generates multiple (000s) processes on database server. DB contains 10 schemas with several huundred tables Realy similar to this issue https://github.com/qgis/QGIS/issues/31101#<https://github.com/qgis/QGIS/issues/31101> Is there any workaround for this ? Thanks [cid:image005.jpg@01D7AEEF.96D57FB0] Sylvain PIERRE Chef de projet système d'information Direction des Systèmes d'Information et du Développement Numérique Service Projets et Ingénierie Numérique Collectivité européenne d'Alsace Tél : 03 88 76 68 88 sylvain.pie...@alsace.eu<mailto:sylvain.pie...@alsace.eu> www.alsace.eu<http://www.alsace.eu> [facebook]<http://www.facebook.com/toutelalsace> [twitter] <http://www.twitter.com/toutelalsace> [insta] <http://www.instagram.com/toutelalsace> _______________________________________________ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org<mailto:QGIS-Developer@lists.osgeo.org> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
_______________________________________________ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
