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