I am in the process of building a website for my company. The case is like this: Our dealer should be able
to place an order, which may contain even 100 items. (this we've done already). Coming to the order
processing part, every item in the order has a different delivery date, different invoice number, etc. As
soon as the sales office receives an order, it has to go to the "manage orders" module and by giving
delivery date, accepted delivery quantity, etc.for each item of the order, an automatic mail need to be
sent to the dealer as an official acknowledgement.
This seems to be a complex case for us. We have around 700 dealers. Assuming that we get 20 orders/day
and assuming each order has 50 items, the sales office user need to give delivery dates & accepted
delivery quantity to 50 x 20 =1000 items per day. Just imagine the web traffic. Now, this is our problem.
For your kind information our site is .net based.
How can we get out of this bottleneck? I'll be very thankful to you if i get your advice on this topic.