Re: Raw partitions / cooked files

In article <1812@rand.mel.cocam.oz.au> shaneb@mentat.mel.cocam.oz.au writes: >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? Filesystem read ahead (breada). Try the same thing while other processes are busily MODIFYING filesystem files.... ________________ Kevin A. Closson, Senior Technical Support Engineer voice: (503)578-3072 World Wide Technical Support, Database Group FAX: (503)578-5453 Sequent Computer Systems 15450 SW Koll Pkwy (MS WIL1-502) UUCP: ..uunet!sequent!kevinc Beaverton, Oregon 97006-6063 internet: kevinc@sequent.com