Benchmark for 1TB Transactional XML System
November 3, 2008
IBM continues to openly benchmark its DB2 pureXML capabilities. Last week at the Information On Demand Conference in Las Vegas, Intel and IBM released details of their latest joint benchmark. The goal of the benchmark is to show the performance levels that you can expect for inserts, updates, deletes, and queries on transactional XML data. This latest benchmark is with 1TB of XML data using the FIXML standard industry format. The results are very interesting. Thanks to the way that DB2 stores XML data, the XML data occupies less than 450GB of disk space when stored in DB2. If you compare the results of this benchmark against previous benchmarks, you can see that the addition of 50% more processing cores provides 48% more throughput (at lower CPU utilization rates), indicating a nice scale-out story. Intel actually measured a 4-CPU server, with 6 cores per CPU, processing more than 6700 XML-based TPoX transactions per second. One of the key aspects of the benchmark is the minimal amount of database tuning needed to obtain these results. For more details, including hardware specifications and database configuration, see the presentation from the conference.