6 reputation
2
bio website vipx1.com
location Dublin, Ireland
age 38
visits member for 3 years
seen May 16 '13 at 19:46

Independent Software Developer


Jun
18
awarded  Autobiographer
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