Retail and system performance

There has been a lot of changes to the AX2012 system with the introduction of the retail module. However if you are not using retail should you disable the key to remove the functionality from your AX solution.

Recently I had a performance issue with posting a price journal. The journal was 200,000 records long, and the journal was taking hours to post. If you look at the code you would see the use of update_recordset and insert_recordset which are bulk insert command, but these only work if the insert and update methods have not been overridden. There was also some code in the posting routine to prevent the overridden insert and update methods being called, but only if NOT retail.

After switching off the license key (System Administration>Setup->Licensing->Licence information) for Retail Headquarter, the performance to post the journal was almost instantaneous.

There is however a side effect of switching of the retail headquarter licence key, when you synchronize the system you will get a number of warning messages related to retail tables. There is no way to remove them from the synchronization result list.

Ignoring the main side effect, if you are not using the retail module or any of the features, you should consider turning off the licence key to improve the performance of inventory transactions. As always you should test this in a non production environment to ensure it resolves the problem and works for your implementation,

Advertisements

4 thoughts on “Retail and system performance

  1. Since turning off Retail also cripples some of the Views, these unfortunately also makes some data in the Standard OLAP cubes go away. Identifying these views and remove the dependency to the Retail configuration is the only way to get these Views back up and get the data back into the cubes.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s