ASP.NET C# periodically updating website value from SQL
Posted on 2014-08-11
I have a website which is displaying data from an SQL database. The data in the database is updated about once every second. At the moment I am using a timer on the website to execute a stored procedure which gets the new value from the database, and then updates the value on the site using an UpdatePanel. The timer "ticks" every 0,8 seconds.
I want the value on the website to be as close to "real-time" as possible, and I was wondering if this is the most effective way of doing this?
Is it possible of "push" the value from the SQL database directly to the website when a new value is inserted into the table using a database trigger?