Performance Improvement for Ax Application.
If you are facing performance problem in axapta then you can do following task to improve performance.
1. First you need to check which table has maximum transactions then you concentrate on those tables which has lot of records.
2. You can create index on tables which is taking long time on select query.
3. You can delete unwanted transaction log data and usage data if required.
4. You can set re-indexing job for all table through job in sql.
5. You can review logic and loop for customization tables you can tune logic to improve performance.
6. You can increase RAM in sql database if its not fulfilling transaction requirements.
7. You can install more AOS and do load balancing.
I hope those points can help you to improve performance.
If you are facing performance problem in axapta then you can do following task to improve performance.
1. First you need to check which table has maximum transactions then you concentrate on those tables which has lot of records.
2. You can create index on tables which is taking long time on select query.
3. You can delete unwanted transaction log data and usage data if required.
4. You can set re-indexing job for all table through job in sql.
5. You can review logic and loop for customization tables you can tune logic to improve performance.
6. You can increase RAM in sql database if its not fulfilling transaction requirements.
7. You can install more AOS and do load balancing.
I hope those points can help you to improve performance.