slowwww application of customer payments

pummipummi Member Posts: 17
Hi,

This is in refernce to topic
http://www.mibuso.com/forum/viewtopic.php?p=129124

Has Anyone Solved this problem of slowwww application of customer payments. It is just crawling

Param

Comments

  • pummipummi Member Posts: 17
    Forgot to tell

    It is Navision 2.6
    on SQL Server 2000
    Customer Ledger Entry is having 45,00,000 records

    Thanks
    Pummi
  • kinekine Member Posts: 12,562
    1) 2.6 is not fast on SQL by design
    2) The process itself is not optimized for SQL (wrong usage of cache etc.)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.