This may be an obvious question (I'm hoping so, since I'm new to this), but I haven't found an overall rule of thumb for this online or in this forum. In a data table for large data sets, the auto refresh is set to every 60 seconds. Should there also be a refresh button for users to feel more in control? I'm not sure if 60 seconds is typically considered a long or short time in general. Really appreciate any insight!
What users would prefer is constant auto-refresh in the background. This can lead to performance issues (as it is in your case I suppose).
At a former company we implemented it with two modes that you could switch between
- Auto refresh: The data was automatically refreshed whenever it needed recalculating
- Manual refresh: The data was never refreshed and shown as outdated if it needed to be refreshed. There was a button to toggle the refresh.