Raw partitions / cooked files
Posted in 1993
Shane Booth — — source: Informix-list mailing list archive (1991-1998)
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. Regards, -- Shane Booth: shaneb@mentat.mel.cocam.oz.au Co-Cam Computer Group, Abbotsford, Vic., Australia