poultarp
asked on
ASP.NET C# periodically updating website value from SQL
Hi
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?
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?
ASKER
Hi Luis
Using the timer works as it should. I was just wondering if there was a way to do this with having to run a stored procedure ever 0,8 second.
I know you can trigger events in the SQL database using triggers, and I was just wondering if it was possible to update a website value from SQL.
Using the timer works as it should. I was just wondering if there was a way to do this with having to run a stored procedure ever 0,8 second.
I know you can trigger events in the SQL database using triggers, and I was just wondering if it was possible to update a website value from SQL.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Why do you want to do "fine tuning" in this? Is the way you're using to get the value time-expensive? Is there a heavy delay from the moment in which the value is stored in SQL to the moment in which is shown in your website?