Skip to main content

Posts

Showing posts from April, 2013

How to improve performance of Import data through Excel template in MSD axapta

There are two ways to improve performance of Import data through Excel template in axapta. Method one: You can Import the excel data into table in a dummy database of sql server or other dummy table in same database. Then you need to Create a odbc connection to the dummy database in the machine After that you need to Create a job in Axapta with odbc connectivity and pull the data by sql query. After reading the data then insert into respective tables of Axapta. You need to write database connectivity script. You can get that code on this blog too. Just use search box. Method two: Second method is you can use standard import functionality but  Don't use excel, you can use custom type importing option then convert your excel data into CSV format and define the table & columns and import the data.I am sure approx 20k records will be import few minutes.I hope This is the better way to import bulk records.

Peroformance improvement points in axapta

If you are facing performance issues in axapta then you can take following action. 1. Re-Indexing. 2. Create new indexes by getting hints from long query and select queries. 3. Check unwanted data in log tables and clear them if not required. 4. Increase RAM Size in sql database. 5. Check your disc where application and database installed. Required to check whether its free or not. 6. Check blocking processes from sql at working time. 7. Load balancing of AOS. I hope you get good hints from here for performance tuning.