I have an app that needs to check a database table every minute. The table is indexed by the time of day and so the app needs to run this check every minute.
What's the best of way of doing this? I can create a background worker thread but if I set it to sleep for 60 secs after each check I will eventually miss a minute because of the overhead of calling the check.
Do I remember the minute I checked and then check, every 15 secs say and if the minute has changed performed the check then.
Or is there some other approach I should use?
I'm using WPF, VS2008 and VB.NET
TIA,
Simon
The DispatchTimer is what you're after - just set the interval you want, and then attach a method to the Tick event - works a treat.
As MrTelly said, the DispatcherTimer is the way to do this. It is tightly intergrated with the Dispatcher queue and makes sure that your callbacks are on the correct thread. Below are some good articles about this class. Some sample code is below detailing a basic example:
// DispatcherTimer setup
dispatcherTimer = new System.Windows.Threading.DispatcherTimer();
dispatcherTimer.Tick += new EventHandler(dispatcherTimer_Tick);
dispatcherTimer.Interval = new TimeSpan(0,0,1);
dispatcherTimer.Start();
private void dispatcherTimer_Tick(object sender, EventArgs e)
{
// Updating the Label which displays the current second
lblSeconds.Content = DateTime.Now.Second;
// Forcing the CommandManager to raise the RequerySuggested event
CommandManager.InvalidateRequerySuggested();
}
Timer vs DispatcherTimer
MSDN Documentation
Not sure about WPF, but in WinForms, there's a Timer control for this. If there isn't one, one way is the following loop:
- Check if we're past the last minute set
- If not, sleep for a short time and check again
- Do stuff
- Check the current time
- Save the minute
- Sleep for 60000ms - current time(sec and ms part) - some value