>>true.
>>But if you edit half data at 11.00 AM and the other half at 17.00 PM and save,
>>without a transaction,
>>how do you maintain consistency if another user changes data that affect partially?
>>
>>must give up something.
>
>Yes, you are right. I guess it is a choice between two devils.
>
>Update...
>
>I just came back from the washroom where apparently I can think better... and I withdraw what I said, you are right, as consistency should be the main factor while deciding the approach to take.

Exactly!

The fact is that much more difficult to develop an application "usable" by maintaining the consistency of the data with a pessimistic lock, than to throw down some select, insert and update and hope on the luck.