Nils Gustav Stråbø (8/22/2010)
Just a thought, but for the clients that are using SQL Server (2005 or higher) you could perhaps use Service Broker?...
http://rusanu.com/articles/ has a lot of very good articles about Service Broker.
Thanks for the link, but just a few quick questions before I spend 2 days reading all those articles :w00t:.
1 - How fast is the response time? I see there's talk about queues, but I can't afford to just sit there and wait for 5 seconds to have my query processed. I've already written the query and it runs in only a few ms and I need to keep it that way (including returning the data).
2 - Can we get the data back as some sort of derived table or does it need to be something like say xml where you need to reparse it before joining to your data?
3 - What's the big safety gain between "sending message" permission VS read only permission on the 1 table where the inventory is saved?