Path: utzoo!attcan!uunet!lll-winken!lll-lcc!ames!pasteur!agate!violet.berkeley.edu!willis From: willis@violet.berkeley.edu (Willis Johnson) Newsgroups: comp.databases Subject: 5 Meg datafile most efficient on Primes? HELP! Keywords: Prime, PRIMOS, files, I/O Message-ID: <10760@agate.BERKELEY.EDU> Date: 10 Jun 88 17:48:23 GMT Sender: usenet@agate.BERKELEY.EDU Reply-To: willis@violet.berkeley.edu (Willis Johnson) Organization: University of California, Berkeley Lines: 11 I'm in the early stages of designing a db system which will eventually be run on a Prime mini under the PRIMOS operating system. I've heard that the most efficient way to store my data is in one enormous file (about 3 to 5 Meg). The system I have been asked to study as a possible model does it this way. Using one giant file strikes me as dangerous from a data integrity point of view and slow when modifying the data. Is there something about the way the OS handles file I/O that makes this more reasonable? As I'm just beginning what looks like at least a year of work, I'd appreciate any pointers or references. Willis Johnson willis@violet.BERKELEY.edu