Performance problem using NAV Three Tier

blopezblopez Member Posts: 16
edited 2011-06-27 in NAV Three Tier

I have a performance problem using NAV Three Tier in a Job.

First, I´ll try to explain how is the architecture. We are using NAV three tier for communicate a web shop with a sync Bridge developed on .NET, who calls NAV using web service.

Currently we are using two types of webservice, for create a correct structure for us, who is a Contact, Customer and Vendor and an Sales Order for the users who are logged on our web (we send a gift to logged users, and customer wants these data reflect in NAV).
Services published are:

1) The page webservice, publish contact card, and NET use it for made an insert.
2) The codeunit webservice, has 3 methods published, one to inser customer, one to insert vendor, (relating both to the contact), and one who makes the sales order with one line with the gift (not posted, only insert).

These Web services are called in order. After The reason for this post, is the next:

- When we make consecutive calls to generate 5000 users, calling all the services, all goes ok.

- When we make consecutive calls to generate 27000 users, calling all the services, problems occur, like cursor error ID:24000, deadloks, etc...also the SQL Server memory occupied by progressively lower until the server crashes.

Currently, we are using SQL Server 2008 with 4Gb RAM. How can we solve this problem? too many records?



  • SogSog Member Posts: 1,023
    I would recommend a buffer between the webshop actions and NAV. A buffer table in the webshop db with the records to synchronize. And when records are found in this table to call the webservice at periodic intervals. (it's probably one record at a time, so anything between 10 and 100 ms should be sufficient. See the logs for the 5000 users to determine this interval).
    So that no matter how many users are on the website (1 - 1.000.000) the locks in NAV are reduced to a minimum. This because the load is not linked to the users on the website.
    |Pressing F1 is so much faster than opening your browser|
  • ScottJonesScottJones Member Posts: 44

    Did you get a resolve for this? I have issue i've posted regarding concurrent calls to web services and wonder if it could be related.


Sign In or Register to comment.