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". 
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.

Comments

Popular posts from this blog

X++ Development basics-Part 1(a) Variables and Data types

List of build versions in Microsoft Dynamics AX and Dynamics365