Speeding Up SQL Operations

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.

Construct	Description
RecordSortedList	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.
RecordInsertList	Allows you to insert multiple records in one database trip. Use the RecordInsertList construct when you do not need to sort the data.
insert_recordset	Allows you to copy multiple records from one or more tables directly into another table on a single database trip.
update_recordset	Allows you to update multiple rows in a table on a single database trip.
delete_from	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.