The mutual exclusion Lock is currently used for everything. That yields unnecessary contention.
Got to use a different lock for readers. When a writer wants to get in, he/she waits to aquire the readers lock first. He then elevates that lock to a write lock. Readers wait on the write lock but share the read lock.
The read lock needs to be counted. It measures the number of concurrent readers.
The write lock is a -1 value of this read-lock.
One lock per table.
Table-of-tables is also a table, so it has its own lock.
The mutual exclusion Lock is currently used for everything. That yields unnecessary contention.
Got to use a different lock for readers. When a writer wants to get in, he/she waits to aquire the readers lock first. He then elevates that lock to a write lock. Readers wait on the write lock but share the read lock.
The read lock needs to be counted. It measures the number of concurrent readers. The write lock is a -1 value of this read-lock.
One lock per table. Table-of-tables is also a table, so it has its own lock.