Click here to Skip to main content
13,142,707 members (55,201 online)
Rate this:
Please Sign up or sign in to vote.
See more:
Iam stuck with my work due to this problem.I searched in the net and very hard to find a solution.The problem is,I have a table in my database which is getting filled with data in every 5 seconds.I need to write a stored procedure to take data every 5 sec and doing some calculations.Iam unable to fetch continuously changing(continuously getting filled)) datas from my table.Is anybody have any idea about doing that?
Posted 18-Nov-12 20:21pm
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Try to use transaction isolation levels[^]
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

Stored Procedure can execute set of queries and/or return result to caller. It can't run repeatedly.
But you can call SP from application side after some interval using timercontrol or like this.
Be careful, it will slow down your application if you fetch data frequently (depending on data volume).
It will be better store modification datetime on table and fetch data depending on that field, it will decrease traffic and faster your application.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web02 | 2.8.170915.1 | Last Updated 19 Nov 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100