How to Think About "Fast Enough"

Ask yourself:

• Is this query blocking a user?
  • Yes - Aim for sub-second to low-second response times.
• Is this query supporting a dashboard or interactive page?
  • Yes - Sub-5 seconds preferred; sub-30 seconds may be acceptable with feedback (for example, spinner).
• Is it a background report or batch process?
  • Yes - Performance is relative. It may be fine as-is unless it’s consuming too many resources.