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

[Bo Victor Thomsen]

 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
>
> **
>
> 	
>
> 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
> 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/72556acd/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 8099 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20210921/72556acd/attachment-0001.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 827 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20210921/72556acd/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 853 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20210921/72556acd/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 1038 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20210921/72556acd/attachment-0005.png>