You can improves processing speed when performing these operations: Insert, Delete, Update, Objects Combine, Objects Erase, Objects Intersect, Objects Disaggregate, and Objects Split. These operations modify data causing MapInfo Pro to create transaction data that have indexes. To improve processing speed, you can select to remove these indexes before processing operations. MapInfo Pro recreates them after the operation is complete.
By default, MapInfo Pro has auto smart indexing turned on, but you can select how MapInfo Pro manages indexes as a software preference:
- Auto - MapInfo Pro decides whether to suspend or recreate indexes. If the table contains more than 1000 rows and more than 0.1% of the total rows are to be updated, then indexes are suspended and recreated later.
- On - MapInfo Pro suspends updating the indexes while executing the operation and recreates them when the operation is complete, which improves performance. This can slightly degrade performance in some cases, so we recommend using AUTO.
- Off - The operation executes without suspendingor recreating indexes.
To change the default concurrency setting:
- On the PRO tab, click Options, and Performance to open the Performance Settings dialog box.
- Select a smart indexing setting from the Smart Indexing list.
- Click OK to close the dialog and save your settings.
See also, Smart Indexing.