I have a functioning, but not yet deployed, app that involves dispatching cases to a group of around 30 users. The app uses SharePoint lists as the datasource and has tables like Tasks, Task Events, Employees, Locations, etc. This all works pretty well so far in my prototype. The dispatcher can marry employees to tasks and employee's status is updated throughout the process. All the activity can be viewed/managed by the dispatcher from a screen with multiple galleries filtered to show employees and tasks in various status. The employees will use iPhone devices with a simple screen showing tasks assigned to them.
I have the main data source (tasks) sorted first, then filtered so the sort is delegated to SharePoint and only the X most recent records are returned each time.
In order to keep the data presented fresh, I have used a timer to refresh the relevant data sources (tasks, employees) every minute. My question is, will this present problems with around 30 users having the app open 24/7? Would there be a benefit to collecting the main data source every minute vs. refreshing it? Is there a theoretical limit to the number of requests that can occur in a period of time after which this will simply stop working?
Any and all advice is much appreciated, thanks !
