I am building a .NET web application as an interface to Navision.
In my architecture, the web application reads data via ODBC while it performs transactions (insert and modify records) via NAS through MSMQ.
The question is: is it possible to use multiple NAS to improve system performance?
In particular I can not find a way to bind a request to an answer. The MSMQ interface of Navision in facts does not support TransactionID property of the message.
what is the right way to synchronize multiple NAS to pick up requests from the queue and deliver it to the right requester.
The use of multiple NAS shoold be transparent to the web application.
By now I am using only one NAS and the web application locks between the request and the answer. There is always only one request in the queue at time. Performances are good in my little test environment but I don't know yet what will happen with more web user at time.
Moreover I would like to create two kind of request:
1- Synchronous: the web client locks waiting for the answer
2- Asynch: the web client sends the request (long batch processes) and goes on. Later it will checks for operation results.
Marco
0