VERIFIED SOLUTION i
X

Resolve performance issue while executing a bulk update in MapXtreme

Issue

The user wants to update 3000+ rows in Mapinfo.data.Table based on the some  condition. The user is able to update records one by one, but it takes lots of times to update and exit the loops almost 30 to 40 seconds. 

Is there any option to update as bulk to decrease the execution time.  Below is the snapshot of the code snippet of implementation:

User-added image

Cause

The update statement is correct, but  MapXtreme pseudo key column name " MI_KEY" missing in the SQL statement.

we recommend to use the pseudo key column name MI_KEY in the MapXtreme SQL statements, regardless of the real column name.

Resolution

UPDATED: March 30, 2017


Include "MI_KEY" in WHERE clause of the update statement to improve the query performance.

Environment Details

Product Feature: MICommand/SQL Statements

 

Downloads

  • No Downloads