SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
Technology Stocks : IFMX - Investment Discussion
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  
To: Charles Hughes who wrote (8787)1/15/1998 5:37:00 PM
From: Guy99  Read Replies (1) of 14631
 
Not so sure about hair splitting but recall we were talking about MS SQL Server's locking mechanism. The question was what good is RLL which only applies to inserts. My Understanding is that the kluge was added to support SAP.

In your discussion what you are calling sectors are in SQL Server pages. If you design so that there is one row per page the two are the same. But since SAP puts it's own logical database on top of the RDBMS and utilizes the RDBMS as an access method, it relies on RLL.

The issue is really one of the granularity of the locking that you want to do and whether you want to lock physical or logical resources. If you're going to support RLL why not FLL (field level locking) and if FLL is good how about BLL (byte level locking), then there could be bLL (bit level locking). You can't get any more fine grained since a bit is the minimum size for information. The more fine grained your locking, the greater the overhead to manage to locks.

SQL Server derrived from Sybase which as you may recall was the first RDBMS based on general purpose hardware which was designed for production OLTP applications. At the time, it was decided that page level locking was the correct trade off between granularity an
Report TOU ViolationShare This Post
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  

HomeMailHotSubjectMarksPeopleMarksKeepersSettings
Terms Of UseContact UsCopyright/IP PolicyPrivacy PolicyAbout UsFAQAdvertise on SI
© 2026 Knight Sac Media.  Data provided by Twelve Data, Alpha Vantage, and CityFALCON News