adamtrask
asked on
Using the timer
Good morning experts,
I need a way to have my code automatically check the database for newly added records.
This check should be done at regular short intervals of around 4 to 5 minutes. I believe the only way to do this is by using a timer.
So, would you please show me how to set up the timer to fire an event every 5 minutes.
I also hear that the timer uses a lot of system resources and I need to know if it would significantly slow down the application. Please advise.
Thank you
I need a way to have my code automatically check the database for newly added records.
This check should be done at regular short intervals of around 4 to 5 minutes. I believe the only way to do this is by using a timer.
So, would you please show me how to set up the timer to fire an event every 5 minutes.
I also hear that the timer uses a lot of system resources and I need to know if it would significantly slow down the application. Please advise.
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I've requested that this question be closed as follows:
Accepted answer: 0 points for adamtrask's comment #a40670890
for the following reason:
Éric Moreau: Thank you for your help. I skimmed through some of the articles I found online about SQLDependency, I haven't as yet tried to put it into copde and tiry it, but it looks like it is the way to go... thanks again
Accepted answer: 0 points for adamtrask's comment #a40670890
for the following reason:
Éric Moreau: Thank you for your help. I skimmed through some of the articles I found online about SQLDependency, I haven't as yet tried to put it into copde and tiry it, but it looks like it is the way to go... thanks again
ASKER