Hi loads best practice 130 000 sales orderlines per day

Bgestel

Hi,

Some of you may have some experience with hi loads on NAV.
I would like to hear youre experiences, advice, etc on hardware and software.



The challenge is as follows

assumption1 : they only do sales order input and invoicing , so no wharehouse or production , ...

130 000 sales lines spread over 2600 sales order per day
inputted during 24/7 opperations by an interface (EDI) and 13 sales people.
resulting in
9700 invoices a week.

Don't be affraid to think out of the box here.
assynchonus posting, Sql server replication, staging tables, ...


let's hear it.

vanrofi

hmm, challenging...

Make sure that you have the best possible server setup first...a performing database is key in this!

If running on SQL, make sure that you have the database tuned to the max...There are specialists around (also in NL) who can advise you in that.

You can choose for a Biztalk server and use that standard functionality in Navision. Some disadvantages : High prize and not that many Biztalk specialist around that know Navision functionality as well.

You can choose for an add-on that is designed for this...there are some good and flexible ones in the market, check with you partner or the add-on list. Designing from scratch is like inventing Hot water.

In order to process import and postings you will end up in using NAS-instances (more than one), also there you will find advanced tools for scheduling NAS-services in order to cope with this amount of transactions. Check again your partner or Add-on list.

Anyway, make sure that you find a reliable partner with proven experience in these matter.

kriki

Bert, if I were you, I would directly call Mark for some consulting! Having peaks this high is one thing, but sustaining this high level is another.

130000 lines per day means over 90 lines per second! (Are you sure it is 130000 lines per day?).
First idea : do you real need invoice-documents in Navision? If not, I would directly put then in general journal lines and post them. Thus avoiding inserting/deleting in tables 36,37,112,113 + dimensions.

davmac1

Navision in batch mode processes very quickly on a good server.
You should stage it in batches and do your batch posting after user hours if possible, since posting locks tables. If you can live without consecutive numbers in the ledgers, then you could change the entry numbers to identities and avoid locking the ledger tables when the codeunit gets the next number.
I believe Jorg Stryk has used this method. Maybe he will reply to this post.

Bgestel

I heard marc desided to go on a holiday , so maybe he has his laptop with hem on the tropical island!

and yes the line are for real, in the Frech food industry , very smal amounts are ordered, like 1 kg of meat x, 2kg of meat y, ... 20 more lines.

They currently are running these loads on a AS 400. It is an oppurtunity but we must be sure it is doable in advance.

maybe i need to setup some lab.

kriki

Bgestel wrote:

maybe i need to setup some lab.

Start with a very big server with LOADS of disks!
I would say that at least 10 disks for DB and 4 for TL is not exaggerated!

Maybe a dedicated SAN could be useful. This means a SAN ONLY for the DB!
I have a customer like that and their DB is flying!