You would need to lock the tables between writes. May slow down the system somewhat. On Wed, Jan 19, 2011 at 2:49 PM, James Nzomo <kazikubwa@gmail.com> wrote:
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
-- Regards Brian Ngure