April 2, 2009 at 7:49 am
I am new to MS development, (come from Uniface/Oracle), and I am trying to develop an MS based Incident Control system, (VB/SQL Server) for our local volunteer fire service. Db is fine and front end Apps do all the updates. In a worst case scenario there can be up to 8 operators, all entering movements of appliances, vehicles and other services under their control. They all hit the DB and I'm looking for a way of having the entries made by each user automatically update the various controls in all the other operator app screens. There is also a log table holding a details of all entries and I'm looking for a way of having a VB control on each operator's screen update as a new log entry hits the table, ( as a new entry is written to the log and the new entry then appears as the last entry on the log display on the app screen of each operator). Two of the operators are are likely to be at the fire connected by mobile broadband. I need the updates back to the operator screens a near "real time" as possible. Hence my question. Someone suggested Notification service would be the way to go but I read it is being dropped. So can anyone suggest a technology that will let me do the things I need to do? I'm posting here until I can find the best route to use and then I'll likely move to that forum when I get stuck. Thanks all, Robin Kershaw
April 2, 2009 at 7:53 am
Does it need to be a push service? Would it perhaps be easier to have the client app periodically pull the updates?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 2, 2009 at 8:02 am
Thanks for the quick response. I believe it needs to be a push service as I worried that refilling all the various controls on the app screen may degrade performance at the very time when the operators need their screens to be available.
April 2, 2009 at 11:43 am
You can look at query notifications, though I'm not sure how well it will work in this app.
http://msdn.microsoft.com/en-us/library/ms175110.aspx
Almost all apps that do this use pull. They just do it quickly. VB doesn't need to redraw the entire screen, you have separate parts of the screen updating asynchronously.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply