SAP Knowledge Base Article - Preview

2073695 - load performance - load data slower on IQ16 than IQ15

Symptom

  • Using two identical boxes(1TB memory and 80core) with different versions of IQ
    • One is SAP IQ15.4 ESD#2
    • And another is SAP IQ 16.0 SP08.
  • Loading the same data(one month of the table, about 1.5 million rows), on
    • IQ15.4, it takes 8s
    • Whereas, loading the same data into SAP IQ16.0 PL08 takes 42s.


Read more...

Environment

  • SAP IQ 15.4
  • SAP IQ 16.0 any release
  • SAP IQ 16.1 any release
  • All operating systems

Product

SAP IQ 16.0

Keywords

load, performance, DML_options8, REVERT_TO_V15_OPTIMIZER, "shadow parallelism". , KBA , BC-SYB-IQ , Sybase IQ , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.