8
UPDATE_RECORDSET can become expensive in case of large data sets.
In SQL we commonly resolve this by executing the update in smaller batches:

WHILE ( @@ROWCOUNT )
BEGIN
UPDATE TOP (...) SET ... WHERE ...
END

We would also like to be able to do this from X++.
This would need a TOP clause to become available in the UPDATE_RECORDSET.
When possible also in the INSERT_REDORDSET and DELETE_RECORDSET, and normal UPDATE and DELETE.
Category: Development
STATUS DETAILS
Needs Votes