microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: How can I use Notification Services to notify my applications

Subject: Re: How can I use Notification Services to notify my applications
From: "oleksa borodie"
Date: 27 Feb 2006 01:07:23 -0800
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Hello Joe.

 Thank you for link. It is very interesting for me since I use SQL
2005.

 Unfourtanetly AFAIU using SQLNS is very complicated in my case. SQLNS
should be used for large subscribers amount on large systems.

 QueryNotification is a bit more suitable. I performed some tests and
found that
 - it requires full-time separate connection (so +30 connections will
be opened all time)
 - after client got new record in the queue it will be unsubscribed
from Query Notification and should perform initial SELECT to receive
events. It looks like sequence subscribe-receive-subscribe-receive...
 - if two or more clients are subscribed to the same notification only
the last one will receive notification since RECEIVE will remove
message from queue. So I should create one queue for one client or
execute SELECT instead of RECEIVE when client looks for new events in
the queue.

 I've considered all mentioned above and found that the best solution
will be fill QUEUE on the SQL server in the procedure and pull QUEUE
from client with SELECT. If I replace QUEUE with table I'll get old
good solution without queues, services, contracts and messages. All
will be clear and easy.

Thank you


<Prev in Thread] Current Thread [Next in Thread>