mercredi 9 février 2011

X++ Code Optimzation

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 feteching 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 caculated 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. 

Keep following things in your mind before you start coding in Ax.
1. Whenever you came accross new functionality , don't start coding immediately please first cross check whether the same/similar kind of functionality is there in the standard product. By doing so you will save time for coding,learn ax coding style and also this will help you to understand the various functionalities in the standard product.
2. Start with pseudo-code , just draw sketch on paper how you want the data to flow , which will help you in understanding the different override methods in Axapta.
3. Code should be modular , Instead of writing all the code in one method please write plug and play functions. 

Aucun commentaire:

Enregistrer un commentaire