SAP Knowledge Base Article - Preview

3314045 - Performance degradation when using real-time ADSOs


When queries against an HCPR containing real-time ADSOs are executed, performance is worse than expected:

  1. Queries executed, for example via transaction RSRT or external reporting tools, are leading to a large number of SQL statements against RSPMREQUEST being executed on the system, for example:
         MAX( "REQUEST_TSN" )
         ( ? , ? ) AND "REQUEST_TSN" < ?
       LIMIT  1
  2. The HANA side execution of the queries using TrexViaDBSL calls has slowed down. Upon further investigation of those calls, for example via the python traces that can be created using the debug options in RSRT, we can see that a huge lN list is passed as a filter for 0REQTSN_KEY:

    so.addPlaceHolder(... '"0REQTSN_KEY" <= 20220317124403000018000 or "0REQTSN_KEY" = 20220317124607000000000 
    or "0REQTSN_KEY" = 20220317124725000086000 or "0REQTSN_KEY" = 20220317124734000008000 or "0REQTSN_KEY" = 20220317124736000017000 
    or "0REQTSN_KEY" = 20220317124745000385000 or "0REQTSN_KEY" = 20220317124800000029000 or "0REQTSN_KEY" = 20220317124816000012000 
    or "0REQTSN_KEY" = 20220317124820000028000 or "0REQTSN_KEY" = 20220317124821000039000 or "0REQTSN_KEY" = 20220317124824000011000

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."



SAP HANA, platform edition 2.0


SAP HANA, platform edition 2.0


KBA , HAN-DB-ENG-BW , SAP HANA BW Engine , 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.