Switch to standard view 
  Sybase logo
 
 
 



INTRODUCTION

 

Sybase IQ is a high-performance decision-support server designed specifically for data warehouses and data marts. This cross-platform product runs on Linux, Windows, Solaris, HP-UX, and AIX operating systems. Sybase IQ 15.x is the latest release of the Sybase Inc. flagship analytic server, delivering high performance in loading large volumes of data and processing very complex queries.

Sybase IQ 15.x offers various new features, such as enhanced support for parallelizing queries, improved subquery performance, support for 3-byte FP index, enhanced use of HG indexes for improving the performance of order-by queries, reduced temporary space usage for queries, and improved load performance.

This paper highlights the query and load performance improvements of Sybase IQ 15.x in comparison to the Sybase IQ previous release, Sybase IQ 12.x.

Performance Benchmark

At Sybase, we used this machine configuration for the performance runs:

  • Hardware: 24-core Intel(R) Xeon(R) CPU E7450  @ 2.40GHz

  • Operating system: RHEL 5.2

To achieve a fair comparison, we used the same IQ configuration in terms of resource and schema for Sybase IQ 15.x and Sybase IQ 12.x.

 Click here to view the complete document (PDF)



Back to Top
© Copyright 2010, Sybase Inc.