Answer Posted / vishal the expert
The level and type of information that the lock protects is
called locking granularity. Locking granularity affects
performance. When a user cannot access a row or key, the
user can wait for another user to unlock the row or key. If
a user locks an entire page, a higher probability exists
that more users will wait for a row in the page. The
ability of more than one user to access a set of rows is
called concurrency. The goal of the database administrator
is to increase concurrency to increase total performance
without sacrificing performance for an individual user.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How much ram can a 32 bit os use?
What do you mean by multithreading?
What is the kernel of the operating system?
What is the use of Synchronized keyword?
What are the deadlock avoidance schemes?
What is a command interpreter?
Difference between logical and physical address space?
Can I change operating systems on my laptop?
What's the difference between 32 and 64 bit?
Draw the states of a process in an OS.
What are co-operating processes?
What is the main thread?
Do I install 32 bit or 64 bit office?
Which technology does Pentium use - RISC or CISC?
What are the different types of kernel?