List Info

Thread: Queue or database




Queue or database
country flaguser name
United States
2007-07-26 21:34:45
Is it faster to write to MSMQ or SQL Server.



Here is the scenario.



1.       The application sending messages to the queue is a
TCP service on a
LAN.

2.       MSMQ is on the same LAN, different machine.

3.       MSMQ is on the same server as SQL Server.



I see the difference now. The service in (1) can easily
communicate with
(2). WCF allows that.



To get a (1) -> (3), that SQL Server would need to run
web services over
HTTP.



I think that's right, and if so then I just bought a book
about SQL Server
2005 and Web services J



Ron


===================================
This list is hosted by DevelopMentorŪ  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com


[1]

about | contact  Other archives ( Real Estate discussion Medical topics )