SQL Server Service Broker
- Thread starter nitro
- Start date
http://stackoverflow.com/questions/...-over-frameworks-like-masstransit-or-hand-wri
http://social.msdn.microsoft.com/Fo...r/thread/5ecd02df-9e0e-4e7e-92f6-fcab597d975e
I have used MSMQ but not SSSB but now I will look into it.
Are there C# libraries similar to R? What do you use for stats and data mining stuff In c#?
http://social.msdn.microsoft.com/Fo...r/thread/5ecd02df-9e0e-4e7e-92f6-fcab597d975e
I have used MSMQ but not SSSB but now I will look into it.
Are there C# libraries similar to R? What do you use for stats and data mining stuff In c#?
Iti s a great API to use, but it is not made for anything like order handling. I can see it for accounting etc. (backend). The main problems you face are along:
* Performance. It can be slow at times. In the timeframe of order submission.
* You need to handle outdated orders. Elements in service broker stay there until processed. Your order submitter crashes - half an hour it is up - it will continue woirking on orders in the queue.
As I said - great for stuff going to the backend (fills etc.) where both elements are not disadvantages.
* Performance. It can be slow at times. In the timeframe of order submission.
* You need to handle outdated orders. Elements in service broker stay there until processed. Your order submitter crashes - half an hour it is up - it will continue woirking on orders in the queue.
As I said - great for stuff going to the backend (fills etc.) where both elements are not disadvantages.
If you are interested in a broker with transactional safety/ concurrency then consider a Service Broker in .NET for instance MassTransit or NServiceBus.
They are great frameworks and can handle a high throughput. I recommend such instead of going with SSSB that as previously mentioned is carrying a strange over-exposed enterprise soul.
They are great frameworks and can handle a high throughput. I recommend such instead of going with SSSB that as previously mentioned is carrying a strange over-exposed enterprise soul.
Thank you! I also found this helpful
http://vvella.blogspot.com/2010/08/integrate-c-net-and-r-taking-best-of.html
The problem with MSMQ is that there is a bunch of things that needs to be gotten just right, e.g., how transactions are handled, how exceptions cause rollbacks, how to stop rolling back endlessly (poison messages), how to integrate with long-running workflows so that the state management boundaries line up, etc. AFAIK, MSMQ is a lite messaging system.