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