Quoting Lior Kesos, from the post of Tue, 13 Jul: > I've just read a slashdot story concerning the amazing benchmarks the > New Zeland stock exchange recieved when comparing the run of Oracle on > Windows to Oracle on linux.
it's really fun what you can do with statistics... > They claim to cut a query taking 36 seconds down to 0.03 seconds by > the switch to linux. but the other details are too tedious for a short newspaper article. they probably also upgraded their hardware from a single old fat massive SMP to a LOBOS cluster of fresh spanking new Opterons or what have you, with a terabyte of RAM on each. also the storage is a bitching new set of FC arrays instead of the old SCSI... and so on. should I mention they may also have used the migration to reindex a few tables and reoptimize the storage in 20 different ways? did they compare the test system's speed while idle against the old production system during heavy load? > I've also been told by one of our customers that they experienced > extreme optimization when moving to linux as well in many applications you immediatly feel the change because of lower overhead, but I doubt it will be by 2-3 orders of magnitude! > The article claims this is because of the RAC architecture (which I > assume is available only on linux) that let's it scale so much - but > also in 9i oracle servers on the same hardware you hear of extreme > differences... haven't seen an official claim for that. all hell would have broken loose if Oracle could show such improvements on 1:1 equal hardware setups. RAC is available on all Oracle supported platforms AFAIK. it's not a feature they only developped for linux. > My question is... Why? > How come this run _SO_ much faster on linux? > Is it only due to the RAC affect , Is it a filesystem related thing? or a marketing help from Billy's best friend Larry Alisson? > > If anyone has any clues I'd be interested to use the LAEC (Linux-il > aggregated Experience (with) Computing) to understand this... I think you meant "SMARTs & Aggregated Linux Experience (with) Computing" (short: SMART-ALEC) -- Partially based on a true character Ira Abramov http://ira.abramov.org/email/ ================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
