<No Subject Supplied>

>From naomi Thu Jul 8 8:12:29 MST 1993 remote from qip From: naomi@qip (Naomi Walker) Message-Id: <9307081512.AA01558@qip> Received: from qip by misty.anasazi.com; Thu, 8 Jul 93 08:12:31 MST Received: by qip (5.61/1.2) (from naomi (Naomi Walker) to informix-list@rmy.emory.edu) id AA01558; Thu, 8 Jul 93 08:12:30 -0700 Subject: Re: Raw partitions / cooked files To: informix-list@rmy.emory.edu (Informix List) Date: Thu, 8 Jul 93 8:12:29 MST In-Reply-To: <1812@rand.mel.cocam.oz.au>; from "Shane Booth" at Jul 8, 93 3:19 am X-Mailer: ELM [version 2.3 PL11] Content-Type: text Content-Length: 983 > > We have OnLine databases (version 5.0) on a Sun SPARCstation 10, one on a > raw partition and one on a cooked file. > > For a query involving a join on two tables, where one of the tables is very > small (~10 rows) and we do a sequential scan through the second table > (~40Mb and ~50000 rows), the raw partition takes 2.6 times as long (on > average) as the cooked file to execute the query. I just can't work out why? > It's supposed to be the other way 'round isn't it? > > Details: SPARCstation10 Model 30, OnLine version 5.00.UC3. > I'd your raw partition device type. It should be a character device. When we mistakenly created our partition as a block device, it was severely slooooooow. If thats the case, its pretty easy to change. Just an idea. -- Naomi Walker (aka N7FSA) naomi@anasazi.com Phoenix, Arizona To get the full value of joy, you must have someone to divide it with. ---Mark Twain