Speeding Up SQL Operations [AX 2012]
Updated: February 14, 2012
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
The following constructs allow you to insert, update, or delete multiple records. Using these constructs reduces communication between the application and the database, and it increases performance.
Allows you to insert multiple records in one database trip. Use the RecordSortedList construct when you want a subset of data from a particular table, and when you want it sorted in an order that does not currently exist as an index.
Allows you to insert multiple records in one database trip. Use the RecordInsertList construct when you do not need to sort the data.
Allows you to copy multiple records from one or more tables directly into another table on a single database trip.
Allows you to update multiple rows in a table on a single database trip.
Allows you to delete multiple records from the database on a single database trip.
In some situations, X++ record set operations can fall back to record-by-record operations. For more information, see Maintain Fast SQL Operations.
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).