SAP Knowledge Base Article - Preview

3191710 - Performance degradation (-20%) in ASE16 compared to ASE157 when executing TSQL in a "while" statement

Symptom

  • During migration from ASE15.7 to ASE16 some scripts perform 20% worse when executing TSQL with "while" statements.
  • The result does not depend on any server configuration.


Read more...

Environment

  • SAP Adaptive Server Entreprise (ASE) 15.7 SP130
  • SAP Adaptive Server Entreprise (ASE) 16.0 SP03 PL10

Product

SAP Adaptive Server Enterprise 16.0

Keywords

826420,CR826420,CR 826420,while,performance,ASE 16,ASE 15.7 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

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

Search for additional results

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