Path: utzoo!utgpu!news-server.csri.toronto.edu!bonnie.concordia.ca!uunet!mcsun!hp4nl!orcenl!nlicl1!hbergh
From: hbergh@nlicl1.oracle.com (Herbert van den Bergh)
Newsgroups: comp.unix.aix
Subject: Re: AIX 3.1 File system mystery
Keywords: AIX disk space file system RS/6000
Message-ID: <1405@nlsun1.oracle.nl>
Date: 27 May 91 15:31:11 GMT
References: <509@nwnexus.WA.COM> <1991May18.184923.28785@ariel.unm.edu>
Sender: news@oracle.nl
Reply-To: hbergh@oracle.com
Organization: Oracle Europe
Lines: 11
Nntp-Posting-Host: nlicl1

In article <1991May18.184923.28785@ariel.unm.edu>, sfreed@ariel.unm.edu (Steven Freed CIRT) writes:
|> Data base files are usually the most common type of file with holes.

	I know at least one RDBMS (guess which) that doesn't do that, and 
	for a number of reasons: when updating your database you don't want the
	overhead of the filesystem finding free blocks and more important it
	may lead to file fragmentation, slowing down access to the
	file. So *REAL* databases ;-) won't use files with holes,
	but more likely raw devices (even less overhead).

|> Steve.                    sfreed@ariel.unm.edu