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:
      SELECT
        MAX( "REQUEST_TSN" )
      FROM
        "RSPMREQUEST"
      WHERE
        "TLOGO" = ? AND "DATATARGET" = ? AND "STORAGE" = ? AND "REQUEST_STATUS" IN
        ( ? , ? ) 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

KBA , HAN-DB-ENG-BW , SAP HANA BW Engine , Problem