Sybase Business Intelligence Solutions - Database Management, Data Warehousing Software, Mobile Enterprise Applications and Messaging
Sybase Brand Color Bar
delete

Search for    in all of Sybase.com
view all search results right arrow
  blank
 
 
 
 
 
 
 
 
 
 

 
 
CLICK TO EXPAND NAVIGATION
CLICK TO EXPAND NAVIGATION
 
 
 
 
Support > Technical Documents > Document Types > White Paper-Technical > Performance Comparison of Sybase IQ 15.x and IQ 12...

Performance Comparison of Sybase IQ 15.x and IQ 12.x

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.
 
RSS Feed
 
 
 

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)


 

DOCUMENT ATTRIBUTES
Last Revised: Nov 26, 2009
Product: Sybase IQ
Technical Topics: Data Management, Performance & Tuning
  
Business or Technical: Technical
Content Id: 1065638
Infotype: White Paper-Technical
 
 
 

 
© Copyright 2014, Sybase Inc. - v 7.6 Home / Contact Us / Help / Jobs / Legal / Privacy / Code of Ethics