August 5, 2015 at 12:11 pm
Hi,
I am no SQL expert, so sorry if my question is a lame one..
I have built an application that is extremely time critical. We updates occur on data in SQL the client (a vb.net app) needs to know about it to take action instantly.
The only way I have been able to do this so far on (sql2008r2,2012,2014 express editions) is to have the client application constantly perform a query twice a second to see if any data has changed in a number of tables. Often data won't change for many minutes so its a lot of queries being performed when nothing has happened data wise.....
Of course this is not a great design, as the client application is hammering the server, and the future design of the application required many client application to enable the solution to scale.
It would be so much better if the SQL server could tell the client application when data has changed.. and the client need not continuously query the server...
I can't be the only one doing this type of application, so I am sure there must be a way to do this.....
Any pointers...
Thanks
August 5, 2015 at 12:17 pm
Haven't done it myself, but you should look into query notification.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply