>>Delayed reaction here as I go clean out old messages. What does 'SWAG' mean?
>>
>
>Scientific Wild-Assed Guess or Silly Wild-Assed Guess, at the option of the recipient to translate. Usually, means that there's some intuitive indication that this might be an answer, but I wouldn't bet a beer on it.

Or, it means that the answer makes a lot of logical sense but you haven't spent time in the docs or testing to prove it to yourself and provide evidence for others.

>
>>>My SWAG is not that it's checking for changes, but rather that when it's used exclusively, the whole table is locked, but when it's shared, it has to lock one record at a time, which would take longer.