Hi to everybody,
my problem is this:
1) I have installed the NAS on the server with only 1 license
2) I have realized a based system on ASP.NET, that Query through MSMQ on the SQL DateBase Navision
3) If a Query employs a lot of time to finish, all the other users they stay in attended
4) exists a way for not stopping the Process but to realize a parallelism of the transactions?
God does not play dice with the universe. [Albert Einstein]
0
Comments
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Eric Wauters
MVP - Microsoft Dynamics NAV
My blog
No, because if the NAS is working, even if an other demand arrive, it does not answer.
Eric Wauters
MVP - Microsoft Dynamics NAV
My blog
as the other already mentioned:
NAS is not multithreaded, therefore when the NAS is running a transaction, everything else has to wait until this transaction is finished.
For Commerce Gateway it is a little bit different scenario, because it is working asynchronous, which means that there is no immediatly response like in a web application.
Currently the only way is to have multiple instances of NAS running.
Another way may be to change the programming so that the NAS has to handle only short-timed small transactions like
User A, B and C want to get data. They send the request parallel.
NAS is running A, then B, then C.
But if each request is split up into different requests it may help to get the following response:
User A, B and C send request parallel. Request A consists of 4, B of 2 and C of 3 smaller requests.
User NAS
A1 (needs some time)
B1 A1
C1 B1
A2 C1
B2 A2
C2 B2
A3 C2
C3 A3
A4 C3
A4
HTH,
Rainer