🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: net.database
Article #146

file, record, field, and index locking

#146
From: Michael Shulman
Date: Fri, 06 Sep 1985 16:46
22 lines
1384 bytes
I think I understand all of the problems necessitating
updates by only one user at a time.  But what I don't
understand are the different ways that these locks are
implemented.  What happens to the index file(s) in use
if fields or records are locked?  Is it necessary to
lock the index also?  And doesn't locking the index lock
the entire file?

Also, can you use multiple indices with B-trees or ISAM files?

Thanks...

-- 
                  Michael Shulman
                  Microcomputer Consultant
                  University of Calif, Davis
                  ... ucbvax!ucdavis!deneb!ccrms
                  (916)752-1667 8-12, 1-5 Pacific Time

{Disclaimer: the opinions expressed here are mine alone, and may
             or may not represent those of my employer or 
             the price of tea in China.}
Technical Details
Message-ID: <56@ucdavis.UUCP>
Path: arc1-ca.pugleaf.net!utzoo!watmath!clyde!burl!ulysses!ucbvax!ucdavis!ccrms

Show Full Headers
Complete Article Headers
Relay-Version: version B 2.10 5/3/83; site utzoo.UUCP
Posting-Version: version B 2.10.2 9/18/84; site ucdavis.UUCP
Path: arc1-ca.pugleaf.net!utzoo!watmath!clyde!burl!ulysses!ucbvax!ucdavis!ccrms
From: ccrms@ucdavis.UUCP (Michael Shulman)
Newsgroups: net.database
Subject: file, record, field, and index locking
Message-ID: <56@ucdavis.UUCP>
Date: Fri, 6-Sep-85 12:46:44 EDT
Article-I.D.: ucdavis.56
Posted: Fri Sep  6 12:46:44 1985
Date-Received: Sat, 7-Sep-85 06:40:35 EDT
Distribution: net
Organization: University of California, Davis
Lines: 22