> When user A updates a record, user B needs to see it immediately or at
> least within a few seconds. What's the best way to make this happen?
>

in these cases, I use events - the event receiver must refresh it's
transaction to see the committed update from the first user. (of course User
A's update must be committed)
Alan