Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is lock granularity?

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


Please Help Members By Posting Answers For Below Questions

Can ram cause blue screen?

963


State the advantages of segmented paging over pure segmentation?

1172


Explain page cannibalizing?

971


What is memory-management unit (mmu)?

1077


What is the meaning of busy spin in multi-threading?

1023


In a ram description ddr 2 1066mhz “2.5-3-3-8” what do the numbers in quotes signify?

879


Differentiate between logical and physical address.

1093


What is operating system in computer?

1050


How do I enable blocked content in internet explorer 11?

945


Who invented os?

977


What is operating system and type of operating system?

924


How many stages are there in chkdsk?

1040


What killed mandla maseko?

1015


How does the system detect thrashing?

1174


What is difference between program and x86?

1010