SAP Knowledge Base Article - Preview

2208010 - Performance problem with REFERENCE caches when there are no matches in the database - SAP ESP


  • In an SAP Event Stream Processor (ESP) 5.1 project, a REFERENCE is created to a HANA table and the query caching feature of the REFERENCE is enabled.
  • At run-time, there are performance problems due to a large number of queries being made to the HANA database when these queries do not return data to ESP.



  • SAP Event Stream Processor (ESP) 5.1
  • SAP HANA 1.0


SAP Event Stream Processor 5.1 ; SAP HANA 1.0, platform edition


empty resultset rows streaming processing , KBA , BC-SYB-ESP , Sybase ESP (Event Stream Processor) , 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.