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
Who is Participating?
Éric MoreauSenior .Net ConsultantCommented:
adamtraskAuthor Commented:
Thanks. This is the first time I hear of SQLDependency. Give me time to check it when I get home.
adamtraskAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.