X++ Code Optimization
X++ Code Optimization
Following are the coding tips to improve your Axapta system's performance:
1. Smart Joins : Try to Use Joins instead of nested while loop wherever possible.
2. Select Statement : Mention the field names in the select statement instead of fetching entire row , this will reduce data amount to transfer from database.
e.g " Select ItemId from inventTable "
3. Display Methods : Make sure that generic display methods should be moved at table level and cached by using"Formdatasource.cacheAddmethod".
3. Display Methods : Make sure that generic display methods should be moved at table level and cached by using"Formdatasource.cacheAddmethod".
4. Local caching : Use Variables for storing the constantly used calculated values in loop , by doing so you can reduce the calls to the database and different layers.
5. Monitor the Database Calls : For bulk records updation, deletion,
insertion use RecordSet Based operator like update_recordset , delete_from
and insert_recordset.
6. Aggregate Function: Use sum, avg, minof, maxof and count where applicable.
Because this can utilize the database’s built-in function instead of calculating and analyse
data in Axapta.
data in Axapta.
Comments
Post a Comment