web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / RETAIL POS GETTING SLOW
Microsoft Dynamics AX (Archived)

RETAIL POS GETTING SLOW

(0) ShareShare
ReportReport
Posted on by SHOXF 490

DEAR ALL;

This is to share a problem with you, which we have been facing from quite a few days. If any of you have any suggestions or experience, please feel free to share. Following is the description and steps which we have taken so far to solve the issue;

 

Problem:

New item scanning at POS is very slow. The scan time gradually increases as the number of lines increase. For example if 1st item is scanned in 3 seconds the next would be done in 5 and after that it will take 7 ....., after that 12 lines it will take more than 35 seconds and it will continue to increase.

 

System and Software Configuration:

Core i3, 8 GB RAM, 500 GB HDD,

Windows 7, MSSQL 2008 Express Edition, Retail POS 2012 R3 CU9

 

Steps taken to resolve the issue:

1. SQL performance tuning

2. Re-Indexing

3. POS.exe.config parameter change (pooling=true)

4. different hardware (all are facing this issue)

 

Thanks & Regards

*This post is locked for comments

I have the same question (0)
  • Rodolfo Recalde Profile Picture
    Rodolfo Recalde on at
    RE: RETAIL POS GETTING SLOW

    Hi Muhammad,

    I would like to present some alternatives to find the source of the problem.

     

    a) You can simulate this scenario in a test environment? If yes, use a POS with OffLineDB and without OfflineDB. So we can say that the problem may be in OffLineDB or POS application.

    b) Did you try using SQL Server Profiler? Perhaps you can identify any query that is consuming your POS application.

    c) There are two KBs. Please, if these KBs are not in your environment, install and verify that the problem is solved.

    KB 3122957 POS responding time increases proportionally when scanning items without variants

    KB 3105973 POS performance issue after scanning multiple products

    Any news, keep us updated.

    I Hope this Helps!

    Regards,

    Rodolfo Recalde.

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: RETAIL POS GETTING SLOW

    Hi Muhammad,

    We had been facing similar issues in our customer environment in the past and after applying proper hotfixes provided by MS, we could able to resolve the issue to an extent.....  Rodolfo has already mentioned two in the above post.

    Initial release of AX Retail POS had all such issues. It would be ideal, if you can go with AX 2012 R3, CU10 as it has lot of resolutions to various bugs, specifically related to POS performance. This is just purely the suggestion based on the our previous experiences, although in your live environment, it may not be possible.

    Additionally, ask your technical person to debug the code. You would find at couple of places, system is trying to connect to HO DB to validate the staff / item and hence causing the lot of issues in terms of performance.

    Also check, if you have multiple offers / discounts in the related tables. Just try to remove those records and see the results. At certain places, system is trying to go through all the offers (multiple times) and hence causing the performance issue. Since this would be due to REPEAT Loops, you would not find it in SQL profiler.  

    Please ensure you are doing all the above steps in TEST ENVIRONMENT only.

    Best Regards,

    Vishal Salot

  • SHOXF Profile Picture
    SHOXF 490 on at
    RE: RETAIL POS GETTING SLOW

    Thank You Guys The problem has been resolved without hotfix. i just checked the muliple offer discount and  after remove the multiply discount. the performance issue has resolved. [tag:Vishal] your third recommendation is very useful for me thank you..

  • Verified answer
    Rodolfo Recalde Profile Picture
    Rodolfo Recalde on at
    RE: RETAIL POS GETTING SLOW

    Only to complement, the KB 3105973 may be related to the correction of multiple discounts.

    Maybe that's why, as Vishal said, CU10 solves these problems.

    Thank you for sharing your knowledge!

    ***

    KB 3105973 POS performance issue after scanning multiple products

    Product and version
    Microsoft Dynamics AX 2012 R3
    Fix type: Hybrid hotfix
    PROBLEM

    POS is taking more time to continue scanning after scanning multiple products.


    In addition, you may encounter the following issues:


    1. EPOS performance issue after scanning multiple products with mix and match discounts.


    2. POS.exe is not responding when you set a large quantity on POS.


    3. Retail POS stops working in a mix and match discount scenario.

     

    DESCRIPTION OF CHANGE

    The changes in the hotfix resolve this issue.

    Introduced alternative algorithm for calculating discounts, which is enforced if predefined max number of calculations steps/loops is exceeded. In this case, POS will switch to Marginal Value algorithm, which does not guarantee the best discount but provides much better performance characteristics.

     

     

  • Feng Zhou Profile Picture
    Feng Zhou 1,575 on at
    RE: RETAIL POS GETTING SLOW

    Rodolfo,  will those hotfixes need to be installed on all AOS, Async server, Store server and POS registers?

    thank you in advance.  May I have your email to communicate?  Mine is alan.zhou(at)outsourceax.com

  • Community Member Profile Picture
    Community Member on at
    RE: RETAIL POS GETTING SLOW

    Useful post.

  • Muhammad Shafique Profile Picture
    Muhammad Shafique 5 on at
    RE: RETAIL POS GETTING SLOW

    Good martial currently, I am facing this problem.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
Community Member Profile Picture

Community Member 2

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans