Posted by Daz on 10/24/06 19:47

Chung Leong wrote:
> I'm afraid the OP is still thinking in terms of loading up an array
> with existing records to see which not to insert. Sometimes you can get
> away with having a race, but inserting hundreds of records is a long
> operation. There is a reasonable chance that a second select could come
> along and beat it.

I disagree. There is an extremely small chance of having a race
condition, as users can only update their own data, no one elses.
Unless a user is logged on twice, a race condition should never occur.
Even if they did log in twice, they'd have a very narrow window within
which to create the race condition. If they did, they would have to
deal with having duplicated books. Hehe.

Many thanks.

Daz.

[Back to original message]