Hi Perry,
>>The type of buffering (optimistic vs. pessimistic) to use depends on the situation. <<I agree with you there. The app that I was referencing was a low volume app and updates were not likely to conflict ... the main reason I went with pessimistic buffering.
>>Row vs. Table buffering - I have never read anything to indicate a situation where Row is preferred, other than a View needing to be Row buffered in order to index.<<Unless you're using pessimistic buffering .... not a good idea to lock the whole table, IMHO.
-Bonnie