Technology news and Jobs 
VIRTUALISATION Massive speed boost for Ingres databases
VIRTUALISATION Massive speed boost for Ingres databases | Massive speed boost for Ingres databases |
|
| by Stephen Withers | |
| Wednesday, 29 July 2009 | |
|
Page 1 of 3   
Featured Whitepaper
5 Best Practices for Smartphone Support
Nearly 80-fold improvements have been seen on certain queries running on Intel Xeon 5500 series based hardware. According to an Ingres white paper, most studies have found that database engines do not benefit from recent CPU features such as out of order execution and chip multithreading. VectorWise gets its speed from a combination of a high-performance query processor and a new data storage architecture that combines column- and row-wise data, compression, and table clustering. Passing entire vectors of data values through the pipeline and carrying out in-cache processing means more work can be done per cycle, and keeping data compressed until it is actually needed speeds queries that would otherwise be limited by I/O or main memory bandwidth. This also makes VectorWise more storage efficient. According to the white paper, data-intensive workloads only need storage capacity of no more than twice the actual database size, where conventional relational engines are typically configured with ten times the data volume. So how much faster is it? Find out on page 2. |
| < Next story in category | Previous story in the category > |
|---|
