NZX Moves To Oracle On Linux
sn00ker writes "In this story in The New Zealand Herald, we learn that the NZX stock exchange has moved their database systems to Oracle running on RedHat Linux, running on commodity Intel-based hardware. What's really impressive are the performance numbers they're claiming. Quoth the article, "One key query - searching the data on historical trades to identify maximum trade values - has been cut from 36 seconds to 0.03 seconds." An improvement of over 1000 times is spectacular in anybody's books, and is one hell of a boost for the proponents of Linux at the back-end of the financial world."
"We went for Linux, not just because we hated Microsoft, but because the cost was compelling," Phillips said.
Alas gallinaceas de urbe bovis volo
I'm glad to see them move to Linux, but I hope that their execs chose it for the performance advantages. But with a quote the one below, I doubt it.
"We went for Linux, not just because we hated Microsoft, but because the cost was compelling," Phillips said.
One key query - searching the data on historical trades to identify maximum trade values - has been cut from 36 seconds to 0.03 seconds.
this probably has nothing to do with indexing or other table and/or query optimizations. i think we should just show these RAW STATS to microsoft customers and they'd switch instantly.
and monkeys fly out of my database administering butt.