Hello, I would to compare with you about NAV performance. Our customer have a database with huge number of records:
- more than 29.000 items
- more than 180.000 orders / year
- so we have 180.000 shipments and about 20.000 grouped invoices
- so we have about 20.000 ledger entries and about 40.000 payments
- more than 5.600.000 order lines / year (so 5.6 M shipment lines…)
- more than 500 customers (as you can see the repetitiveness of orders is very high)
- working days 6 of 7 / week
- 2 years of data on-line for comparison
The customer now has a proprietary software, we are evaluating the migration to Dynamics NAV. We have done a test inserting all the data above in Dynamics NAV and the result was excellent in term of performance. But other consultants give us contradictory opinions: “NAV is not suited for that volume of data”, “consider AX instead of NAV” and even “abandon Dynamics”!
Can you give me an objective opinion? Any experience with this amount of data?
Thanks a lot for your support.
Bye!
Definitely I would not consider this HUGE but also not small. 5.6 million lines per year is about 20,000 transactions per day. Which is not a lot. But really its not enough information. What are you doing. Which granules will you use.
With proper hardware, and proper tuning and proper system design you should be OK. Make sure you do it properly though.
Thank you David for quickly response.
We would to use basic general ledger, responsibilty centers, sales order management, sales invoicing, all the advanced warehouse (items, pick, shipments…). The orders acquisition will be done out of NAV, by modem or WEB and simply written in NAV by web services. NAV have to do shipping and invoicing.
Similarly to the current hardware we have thought to a dedicated SQL Server, with at least 8 cores, 32 gb of RAM and very fast hard disk.
We did 180,000 orders last year - We have 58,000 items - We have 3,000 customers - System is no problem.
And we’re using an old version & native database to boot. but as David says that’s doesn’t always tell the entire story.
Don’t start worrying about hardware yet. The requirements for a Navision server are quite specific, and the configuration very important. Most likely those people that claimed Navision can’t work with your requirements also had experience of Navision on an under powered server. But you need to really know what the implementation will be like till you start that.