Mike Ault's thoughts on various topics, Oracle related and not. Note: I reserve the right to delete comments that are not contributing to the overall theme of the BLOG or are insulting or demeaning to anyone. The posts on this blog are provided “as is” with no warranties and confer no rights. The opinions expressed on this site are mine and mine alone, and do not necessarily represent those of my employer.
Friday, February 19, 2010
Making the Best of Both Worlds
Why am I so enthusiastic about this new architecture? In tests, by only switching on this architecture in an existing structure we were able to achieve a 9-10 times performance improvement. Time to execute a test run of 2,000,000 SQL statements dropped from 12 minutes to 1.3 minutes. Latency dropped from 13 ms to less than 1 ms. Here is a link to the entire paper describing this architecture:
While the paper describes an Oracle based architecture, the concepts it describes could be used for any read-intensive application with the use of a disk management system that allows preferred-read mirrors to be utilized.
of course the beauty of this architecture is that it makes use of and accelerates your existing IO subsystem without any changes to the tables and indexes or your application.