Re: How can I use Notification Services to notify my applications
Thank you for link. It is very interesting for me since I use SQL
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
- 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
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.