As long as there is an index on the fields then it is not taxing for
the database.


if displaying on and off shift then
select persons from the_database order by onsite,rank
(0 off shift, 1 on shift)

a status update is just setting that persons shift status

add limit 1 if you just want the top of the pile

Dave Caroline