You hit the target: there is no valid reason to put pessimistic buffering on views, because a view (cursor by nature) is already in exclusive possession of the user. Each user gets own recordset, there is nothing to lock.
>Uh, oh. Since I don't use pessimistic...I'll ask the dumb question: why would you *only* use optimistic with views? If the need for pessimistic is valid (and it certainly is even if *I* don't use them) then why wouldn't it still be valid when using views?
>
>TIA
>
>>It seems to me that John left UT. If he went to set pessimistic buffering on a view, it can take some time :). Views are for optimistic buffering.
Edward Pikman
Independent Consultant