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

Give a brief description of the following terms: a) Play head b) Symbol c) Tweening d) ActionScript e) Frame rate f) Library panel g) Masking h) Context – sensitive Property Inspector i) Bandwidth Profiler j) Frame Label

1983


What is multi tasking, multi programming and multi threading?

997


What is turnaround time?

1035


Differentiate between pre-emptive and non-pre-emptive scheduling.

1227


What does the 400 mhz signify in a ram specification?

992


Explain about Different types of real-time scheduling?

1090


What is throughput?

1043


Which one you will use to implement critical section?

2228


Tell me what is executive in windows nt?

1072


What is operating system in computer?

1070


What is synchronization? What are the different synchronization mechanisms?

1069


What are types of operating system?

998


What is a long term scheduler & short term schedulers?

991


Explain the command rate in reference to ram?

1073


What is the Difference between Loading and Linking ?

17104