Quick question about the transport

[Pablo Agirre]

   I have several instances of a WinForm app, that deal with a SQL Server.  When one of the client do some change, i need to notify the change to the others instances.

   I have revised Sqldependency(), but maybe nginn would be better and simpler. The publish and subscribe method is better for my data.

   But, I have one requirement, my app can use ONLY one TCP port, the one used for SQL Server data (1433).

   Does the nginn mechanism pub/sub works inside the SQL Server tcp port connection ?

[Rafal Gwizdala]

Hi Pablo,

The good part is that only a database connection is required for sending and receiving messages with nginn-messagebus, so 1433 port is sufficient.

But I wonder if the pub-sub communication model implemented in nginn-messagebus is good for your case. NGinn-messagebus handles distribution of messages from publisher queues to subscriber queues so a simple use of pub-sub in your case would mean that every client app would have to run its own queue and to subscribe for events at all other queues, which is very impractical. The more workable approach would rather use a single central queue where the events would be sent by every application, and then distributed to all subscriber queues. Maybe I could suggest something if you gave more information:

1. Is the number of client applications fixed, or does it change?

2. Are the client applications running all the time (services/daemons) or are they only running when somebody's using them?

3. If a client app is inactive (not running), is it still interested in receiving event notifications that were generated during inactivity time, or can these events be ignored?

Best regards

R

--
You received this message because you are subscribed to the Google Groups "nginn-messagebus" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nginn-messageb...@googlegroups.com.
To post to this group, send email to nginn-me...@googlegroups.com.
Visit this group at http://groups.google.com/group/nginn-messagebus.

[Pablo Agirre]

Hi Rafal,

Thanks for your answer.

You're right, I think SqlDependency() will be better for my design.   The information is not critical and not allways needed on clients, and the partners for my communication are allways one DB and several clients, but they do not talk between them.

Thanks.