How Do I Improve Performance Connecting to SQL Server - MapInfo_Pro - 2023

MapInfo Pro Help

Product type
Software
Portfolio
Locate
Product family
MapInfo
Product
MapInfo > MapInfo Pro
Version
2023
Language
English
Product name
MapInfo Pro
Title
MapInfo Pro Help
First publish date
1985
Last updated
2023-09-12
Published on
2023-09-12T16:39:16.995549

To improve performance when accessing large SQL Server tables, add a Multiple Active Result Sets (MARS) connection setting to the connection string in the live access .TAB file. The connection attribute to update is \DATALINK\ConnectionString, for example:

"\DATALINK\ConnectionString" = "DSN=local-native10;UID=username;Trusted_Connection=Yes;APP=MapInfo Pro;WSID=hostname;DATABASE=test;MARS_Connection=Yes;"

You may also add the MARS connection setting to the connection string of MapBasic Server_Connect( ) command.

Note that a MARS connection:

  • Does not work for SpatialWare tables.
  • Only applies to SQL Native Client or SQL Server Native Client 10. Other connection types so not benefit from this setting.