Speeding Up SQL Operations in AX 2009 Development

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.