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.
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.
No comments:
Post a Comment