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