AnsweredAssumed Answered

Dueling Data-Entry Scripts

Question asked by richardsrussell on Jun 25, 2018
Latest reply on Jun 26, 2018 by richardsrussell

At 10:05:11, User A activates Script X to create 1000 records in Table Y, each with a serial number auto-entered in PrimaryKeyY, where the next value to be entered is 123456.

 

At 10:05:12, User B activates the same script to create 2000 records.

 

Chances are that User A's activation of that script is still running when User B's request arrives.

 

What happens?

 

Will the values of PrimaryKeyY be interlaced?

Outcomes