Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You can configure your web farm with "Sticky IP".</p> <p>That means that when a client connects to a web farm he is routed to one machine. All following requests from that client will go to the same machine on the farm. This works a bit like the routing service you've described in your question.</p> <p><strong>EDIT</strong></p> <p>It is probably simplest to implement a polling system where the silverlight client asks the web server "is there anything new for me", that request would contain the time of the last time the client asked. The list of new things would be stored in a database table. So no problem which web server you hit. </p> <p>Also, you need to watch out for limitations in Silverlight WCF, if I understand correctly it does not implement all of WCF.</p> <p><strong>EDIT 2</strong></p> <p>In the case that you need to communicate to all users at the same time, the call does not need to go all the way down to the database. This can be cached in memory at the WCF service level, the other clients will get this from memory, giving you better performance and less load on the database.</p> <p><strong>EDIT 3</strong></p> <p>As long as you are using a silverlight client it is difficult for the clients to communicate directly with each other. There are two possiblities although they require extra work/cost:</p> <ul> <li>use Azure service bus, each client talks to an endpoint in the cloud which is converted to direct communication.</li> <li>Drop using silverlight, use a client that can expose a WCF service endpoint. When the client starts up it registers the endpoint with the server. Each client can then ask the server who is online and send a message directly to the client.</li> </ul>
    singulars
    1. This table or related slice is empty.
    1. POWCF Duplex Communications in a clustered environment
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USShiraz Bhaiji
    1. USShiraz Bhaiji
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COThis isn't the correct solution, tho, since it provides no way for me to communicate with all users at the same time. Only all users on the same machine. The examples I've seen all use in-memory objects / lists to push data to all connected clients. What about clients connected to a different machine entirely?
      singulars
      1. PO
      1. USJustLoren
    2. COI'll clarify my question :)
      singulars
      1. PO
      1. USJustLoren
    3. COYour database Polling answer is viable, but I can't help but feel it would be CPU intensive on the server. Every .5s would be another db hit asking "any new messages?" Are there any other solutions?
      singulars
      1. PO
      1. USJustLoren
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload