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 ONE Support launchpad (Login required).

Search for additional results

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