Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Performance problem using NAV Three Tier
blopez
Member Posts: 16
Hello,
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?
Thanks,
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?
Thanks,
0
Comments
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.
|To-Increase|
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.
Cheers
Scott