Hi,
I have a database table that has all the rows for events people have inputed in their personal calender.
Events can be also set to re-occur every x days.
I need to create some kind of a polling service (windows service I guess) that will check if any event is re-occuring, if it is I need to send out emails to those users notifying them of the event (on the day it is suppose to re-occur).
Should keep polling the main table every 1 hour, or would it be better to create a secondary table that contains the days events, this way I can simply do faster lookups on that table and not have to check the other main table that will have thousands+ rows in it. (potentially hundreds of thousands to millions).
1 answers
It looks like your concern is performance related. I would build a test database and add 1-2 million rows in it then run your query against it. If performance of the query is okay (runs in a second or two) then a direct query polling every hour should be fine.
answered 8 months ago by:
0
Just curious why you would need to poll every hour if you are only worried about events that occur on re-occuring days?
Seems like you could just poll once a day.
answered 8 months ago by:
0
This post was imported from csharpfriends, if you have a similiar question please ask it again.
All previous members have been migrated, hope you enjoy the new platform!