3
Answers

Want to run the multiple wcf service on the same machine

dipak mange

dipak mange

8y
334
1
We have one wcf service hosted using window services. This service works as the server and can accept TCP connections. currently it works fine with 70 connections but when connections exceeds the service goes slower and new connections do not get established. So now on the same machine we want to run multiple instances of this wcf service owith its own configuration so that we can have more than 200 connections. Questions is if we add multiple end points in the service does it create two separate instances of services running in separate processes or thread? or is it same service instance accessed by different end points? 
Answers (3)
2
Nitin Sontakke

Nitin Sontakke

NA 11.7k 2.2k 8y
Separate table is a good idea. But about "creating records in it as soon as product request is created", I am not so sure about.
 
My suggestion:
 
t1 - product request : insert record as soon as product request is created. 
 
t2 - product request approvals : a set of 10 records which indicate which approvals must be obtained. Note that this table DOES NOT have record for actual approval received.
 
t3 - product request approvals received : again a set of 10 records which indicate that approvals actually received. There may be 0 records at the beginning but insert each record as approval is received. This has who approved, when approved, comments, etc.
 
t4 - Optional - auditing of t3 table. In this log each change in t3 (insert update delete of t3) Who gave approval and then revoked it, etc. 
 
The benefit of above approach is you can select records from  t2 left outer join with t3 and know pending approvals. I am sure you will need it some time. Note that t2 is just a template table. This approach protects you from increase / decrease in number of approvals.
 
 
Accepted
0
Nitin Sontakke

Nitin Sontakke

NA 11.7k 2.2k 8y
Thanks!
 
Feel free to ping for any other question(s) you have face in the process. 
0
Bennie

Bennie

NA 6 0 8y
Thank you Nitin.  The missing link for me was the Left Outer Join and inserting after approval.  You have cleared things up.  
 
9 years ago I was just getting started as an independent consultant and was hopeful to pick up as a programmer.  Consulting opportunities directed me in other areas, BA and Systems admin.  I now have the fortune to implement small projects that are mostly data capture and reporting.  A great opportunity to learn.
 
Thanks again
 
 
0
Nitin Sontakke

Nitin Sontakke

NA 11.7k 2.2k 8y
Somehow it surprises me that you ask your first question after full 9 years after becoming member of this forum.