N
navsingh013
Guest
We have a window service which have multiple methods to send sms & emails to selected people depending upon the scenarios. SMS & Emails can be send at any time(multiple) of the day so we have set the time interval to 3 minutes.
We have multiple databases like more than 200, so we have implemented a foreach loop which fetches all databases and scan each databases one by one and send sms or email if required. Though interval time is 3 minutes but it does not calls again until the last cycle is completed.
We have multiple cases in which multiple databases have data for which we need to send sms and email, our window service uses foreach loop, so it takes time to process all databases and there is lag of around 12-15 minutes in sms & email which is not acceptable by our clients.
We have tried parallelfor but it did not work.
Window Service is installed on database server.
Any suggestion would be appreciated.
TIA
Continue reading...
We have multiple databases like more than 200, so we have implemented a foreach loop which fetches all databases and scan each databases one by one and send sms or email if required. Though interval time is 3 minutes but it does not calls again until the last cycle is completed.
We have multiple cases in which multiple databases have data for which we need to send sms and email, our window service uses foreach loop, so it takes time to process all databases and there is lag of around 12-15 minutes in sms & email which is not acceptable by our clients.
We have tried parallelfor but it did not work.
Window Service is installed on database server.
Any suggestion would be appreciated.
TIA
Continue reading...
