| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 9 months |
| seen | May 16 at 19:46 | |
| stats | profile views | 2 |
Post Grad. C# developer
|
Sep 23 |
awarded | Student |
|
Sep 1 |
comment |
Update Table with Network Client Connection Status, I need help with DB design. SQL 2008 Ex R2 Thanks for your reply and I am going to make those changes to the DB Design. One of my other motivations which I should have mentioned was that I wanted to query the DB as little as possible. I didn't want 1 query every thirty seconds. With your suggestion and a local properties that only commits to DB on Status change-over I should be good enough. |
|
Aug 29 |
comment |
Update Table with Network Client Connection Status, I need help with DB design. SQL 2008 Ex R2 I am going to go with a local version of the device also. If the Device changes status and it's confirmed I will then update the database version with the new status, either Online or Offline. In this way I should get months instead of weeks before my Connections Index is in the millions. |
|
Aug 29 |
asked | Update Table with Network Client Connection Status, I need help with DB design. SQL 2008 Ex R2 |