Skip to main content

Posts

Showing posts with the label tips and trick to improve application performance

Performance points in axapta

Performance points in axapta How you code access to your data has a major impact on the performance of your code and system; here is a list of rules to go by: • Unless you really need to and have tested the execution plan very well, don’t use hints in database statements; the database optimizer will do a better job, and a bad hint can really hurt performance. • Use table joins instead of using loops to walk through your data; this reduces the number of statements traveling around and the amount of data, plus it offloads processing of data to the database. • Use aggregate functions where appropriate instead of aggregating in code. • If you are deleting many rows that match specific criteria, use the delete_from statement instead of delete, as it performs better. • If you are updating many rows that match specific criteria, use the update_from statement instead of the update statement, as it performs better. • Think well about your indexes: lack of good indexes will lead to ful