Skip to main content

Schedule Screen Performance Improvements (Round 2)

Faster Schedule Loading

The schedule screen now loads significantly faster. We've reduced the number of database queries from 7 to 4 per page load by:

  • Inlining break data into the main shift query instead of fetching it separately
  • Combining location and role lookups into a single optimized query
  • Merging shift and leave location checks into one query

Permission Changes Apply Immediately

When a staff member's permission level is changed (assigned or unassigned), the update now takes effect immediately instead of being delayed by up to 10 minutes.