How can I verify the result set cache is being used in EDS?

Solution Verified - Updated -

Issue

  • When we issue SQL statements from client applications using cache hint to cache result set for an hour if same where condition with same values in the where clause passed as parameter, we want to use cache data, instead of querying the data source every time. How to verify that it is using cache data in the sub-sequent query run for an hour to confirm ? Any entries in the server.log or any system tables gives cached entries or teiid-command.log indicates result set cache data?
  • How can I verify the result set cache is being used in EDS?

Environment

  • Red Hat JBoss Data Services (EDS) 5.3.1

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In