DB question:
Do we have to allow for concurrent reads to a single record?
Meaning should we allow:
thread A reads record 1
// in the middle of a read vm switches threads
thread B reads record 1
This would be dangerous if thread B is writing to a record. This scenario would require an addition locking mechanism than the one provided.
Or
Should the second request to read the same record block until the first request is finished.
I think the project only requires that we have to allow for concurrent reads to the entire database but not a single record. In this case we would (using the specified lock and unlock)lock on a record for either reading or writing.
Brandon