Project: QGIS

Version: 3.18

Feature: Improve MSSQL loading with predefined parameters

To reduce layer loading times, the map layer extent can be precomputed, and primary keys can be specified, removing the need for QGIS to calculate these characteristics and improving performance.

This is done by extending dbo.geometry_columns tables and adding the following extra columns, which may be populated accordingly by database administrators:

• Extent : qgis_xmin, qgis_xmax, qgis_ymin, qgis_ymax
• Primary key : qgis_pkey

In the database connection configuration widget, there are now two extra checkboxes which make use of these parameters:

• Use layer extent from the extra columns
• Use the primary key from the extra column

This feature was funded by ms.GIS

This feature was developed by Lutra Consulting (Vincent Cloarec)