Consider this happening in the 1st second of 10:15 am

@10:15:01:025 User 1 inserts to Table 1
@10:15:01:050 User 1 Selects last inserted pkey from Table 1
@10:15:01:075 User 1 inserts to Table 2

All good

--------------------------------------------------------------------------------------------------------------------
Now consider this alternate scenario happening in the same 1st second of 10:15 am

@10:15:01:025 User 1 inserts to Table 1
@10:15:01:030 User 2 inserts to Table 1
@10:15:01:050 User 1 Selects last inserted pkey from Table 1
@10:15:01:075 User 1 inserts to Table 2

Chaos! All in less than a second

_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke