I am looking for feed back on this topic. Any of your thoughts or comments are appreciated. I am constructing a multi user database and I am concerned about record looking as most of the databases I have worked on before had a small number of users. I have a table that a dozen people will be adding records to all day. What they are doing is not that involved, but each time they do it they will add a record to a table. Since all 12 people are going to be adding records to the end of this small 4 column tabel all day, I am concerned about them having record writing conflicts.
One area I could use your feed back in is the "page" of 2 kb and how it plays into the following scenario as it relates to optimistic locking (no locks) or edit records locking.
Say we have two users, user01 and user02. Say user01 and user02 are both adding a record to this table. User01 finishes first and saves their changes. Then a few seconds later user02 saves their changes.
1) Edit records locking
If I am understanding the page idea correctly, edit records locking wouldn't allow for this scenario with my small table that's probably less than 2kb per record. Only one user could have been adding a record. If user01 had started first, user02 couldn't have started adding anything because user01 has locked the bottom of the table. Thus productivity would be very poor because only one person could add records at a time.
- Is this correct?
This would allow for both user01 and user02 two be adding records at the same time. But will user02 be prompted about user01's addition, user02 getting an over write last persons update message?
Again I really appreciate you help here as it is most needed. Thank you for your time and happy holidays.