Article View: net.database
Article #146file, record, field, and index locking
From: Michael Shulman
Date: Fri, 06 Sep 1985 16:46
Date: Fri, 06 Sep 1985 16:46
22 lines
1384 bytes
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!ccrmsShow 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