Compare SQL and Native network requirements?

pdj
Member Posts: 643
I have always found NAV being very demanding regarding low latency for the network connection. We usually uses the NETTEST results (the Performance table) to compare the network capability of different sites. We have ended up recommending Citrix for sites not capable of delivering at least 3000 packets of 100bytes a second or 800 packets of 4000 bytes. (I know this is way more demanding than the Microsoft recommendation…)
But this recommendation was made for the Native database. I assume the SQL option is transmitting bigger but fewer packets. Is this correct, and has anyone done any comparing of number of packets for identical processes in SQL and Native? I would like to know if it only is 10% less packets or maybe 90% less. I currently have a client with poor nettest results but would like to avoid Citrix. I don’t know if I should suggest SQL for them. I know NAV SQL requires all sort of optimizations to work, I’m just curious if the network latency requirement is different.
But this recommendation was made for the Native database. I assume the SQL option is transmitting bigger but fewer packets. Is this correct, and has anyone done any comparing of number of packets for identical processes in SQL and Native? I would like to know if it only is 10% less packets or maybe 90% less. I currently have a client with poor nettest results but would like to avoid Citrix. I don’t know if I should suggest SQL for them. I know NAV SQL requires all sort of optimizations to work, I’m just curious if the network latency requirement is different.
Regards
Peter
Peter
0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions