Connection to database
Not sure if this is the correct forum or not, but here goes.
I wrote an application in asp a while back that was designed to track employee status in a call center. There were two clients. One was for the phone operators and the other was for the supervisor. Both clients used IE. The employees would click a button to change their status. This would update a database with their name, current status, and the time that they changed their status. Each employee was able to see the status of all the other people in their group and the supervisor was able to see all the employees in the groups they were responsible for. The was a set of rules the each group had and each request to change the status was run against these rules. This was used to regulate how many people were allowed to take a break at one time, how many people were at lunch , and must importantly, when they were on the phone taking a call.
I'm trying to move this to a C# application. In asp, I was able to refresh the data by reloading the page every 30 sec. for the supervisor. I would like to know what type of connection I need for the supervisors client so that the data is updated as soon as it's changed. For instance, if employee #2 is on break, I need the supervisors client to display the amount of time that he has been on break and change his status back as soon as employee #2's status changes on his client.
Here's my question:
Is it possible to have a active connection to an SQL database so that changes are updated immediately?
And what kind of load will this put on the server?
Is this even possible?
Thanks in advance