To solve part of the problem, I will be creating a separate service on a different AWS instance that connects to each data source and interacts with the DB independently from IIS.
Should this be done on an interval (say, every five minutes), looping through each of the users’ accounts and pulling data, or alternatively, should I use a multithreading approach, where each account has an associated polling thread?
Keep in mind, the technologies used are: ASP.NET MVC 4, SQL Server.
Your insight is much appreciated.