[QGIS-Developer] QGIS connections to MSSQL generate multiple (000s) processes on database server

[PIERRE Sylvain]

Thanks Bo ,
It seems to be a valid workaround for us.
I'm interesting in such procedure.

Thanks for your help

[cid:image001.jpg at 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.pierre at alsace.eu<mailto:sylvain.pierre at 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-bounces at lists.osgeo.org> De la part de Bo Victor Thomsen
Envoyé : mardi 21 septembre 2021 09:04
À : qgis-developer at 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 at 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.pierre at alsace.eu<mailto:sylvain.pierre at 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 at lists.osgeo.org<mailto:QGIS-Developer at lists.osgeo.org>

List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20210921/3ae297e3/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 8103 bytes
Desc: image001.jpg
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20210921/3ae297e3/attachment-0002.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 827 bytes
Desc: image002.png
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20210921/3ae297e3/attachment-0006.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 853 bytes
Desc: image003.png
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20210921/3ae297e3/attachment-0007.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 1038 bytes
Desc: image004.png
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20210921/3ae297e3/attachment-0008.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.jpg
Type: image/jpeg
Size: 8024 bytes
Desc: image005.jpg
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20210921/3ae297e3/attachment-0003.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image006.png
Type: image/png
Size: 895 bytes
Desc: image006.png
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20210921/3ae297e3/attachment-0009.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image007.png
Type: image/png
Size: 851 bytes
Desc: image007.png
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20210921/3ae297e3/attachment-0010.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image008.png
Type: image/png
Size: 1039 bytes
Desc: image008.png
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20210921/3ae297e3/attachment-0011.png>