Sumit Potbhare

Microsoft Dynamics AX for Retail

ePOS Performance | Switch speed from Online to Offline mode

Hi Guys, This is the second blog from my ePOS performance blog series. You might have viewed my last blog on ePOS | Retail Implementation using SQL Express which will help you in reducing the Database size when dealing with SQL Express. Here we will talk about reducing the time for ePOS to switch between Online to Offline mode.

For any Retailer, POS should be up and running each and every time if there is loss in connection with the Store server or any any other activity being carried out at the Online Database. This required Offline mode to be enabled in order to support continuous operation at POS. So if connection is lost, the POS will switch to Offline Database and should be able to carry out cash and carry sales.


The switching between the Online and Offline Database happens automatically in ePOS whereas the vice versa has to be done manually. Switching automatically from Offline to Online mode is currently not supported in ePOS but can be achieved through customization. I would rather not recommend to go for customizing this automatically as this might cause issues.

Its been observed that the automatic switching between Online to Offline mode takes too long to switch. To reduce the timeout for switching, add the “Connection Timeout” node in the POS config file.


<?xml version=”1.0″ encoding=”utf-8″ ?>
<section name=”AxRetailPOS” type=”LSRetailPosis.Settings.ConfigFile.AppConfiguration, SystemSettings, Version=, Culture=neutral, PublicKeyToken=31bf3856ad364e35″ />
<AxRetailPOS OfflineDatabaseConnectionString=”Data Source=.\sqlexpress;Initial Catalog=AXPOSOFFLINE;Integrated Security=True;Persist Security Info=False;Pooling=True;Encrypt=True;TrustServerCertificate=True;Connection Timeout=1
StoreDatabaseConnectionString=”Data Source=\SQLEXPRESS;Initial Catalog=AXPOS;Integrated Security=True;Persist Security Info=False;Pooling=True;Encrypt=True;TrustServerCertificate=True;Connection Timeout=1

The initial timeout is around 20-45 seconds which is not even acceptable for some of the Retailers but by this setting the timeout is reduced to approx. 6 seconds.

Feel free to reach out for any clarifications. If you like my blog posts then comment and subscribe to the blogs.

Enjoy RetailDAXing.

Disclaimer: The information in the weblog is provided “AS IS”; with no warranties, and confers no rights. All blog entries and editorial comments are the opinions of the author.



Single Post Navigation

Leave a Reply

Please log in using one of these methods to post your comment: Logo

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

%d bloggers like this: