Peter Dunkley writes:
I suppose an alternative function that just needs ruid could be written - but it would be much less efficient as it would have to linearly search all records (unless an additional hash on ruid is added - and a DB index on it too).
thanks for the explanation. now that we have ruid, the rest of usrloc has not clearly kept up with it. a new hash on ruid should be added. usrloc table already has unique index on ruid, which means that in db only mode, it should be quite easy to make the query only based on ruid.
-- juha