SAP Knowledge Base Article - Preview

3316257 - Backoffice slowness due to counting total number of records - select COUNT(*) as CNT from (...) CNTTABLEALIAS

Symptom

Backoffice requests are slow. After checking Dynatrace metrics you could see that most time consuming are SQL statements similar to this:

select COUNT(*) as CNT from (...) CNTTABLEALIAS


Read more...

Environment

SAP Commerce

SAP Commerce Cloud

Product

SAP Commerce Cloud all versions ; SAP Commerce all versions

Keywords

KBA , CEC-SCC-CDM-BO-SRC , Search , CEC-COM-ADM-BO , Backoffice , How To

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.