Speeding Up SQL Operations
Collapse the table of content
Expand the table of content

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: New book: "Inside Microsoft Dynamics AX 2012 R3" now available. Get your copy at the MS Press Store.

Community Additions

© 2016 Microsoft