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.