Debbie Steigner created TEIID-2706: -------------------------------------- Summary: Cache hint for resultset cache in user query doesn't work Key: TEIID-2706 URL: https://issues.jboss.org/browse/TEIID-2706 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.7.7 Reporter: Debbie Steigner Assignee: Steven Hawkins I enabled TRACE logging and Command Logging to see if the Resultset Cache was being used on my queries. If I use the ResultSetCacheMode=true on connection string you can see Teiid using the cache instead of pulling from source again: This is displayed the first time the query is run, it's loading the Cache: 2013-10-18 07:17:52,951 TRACE [org.teiid.PROCESSOR] Adding to global/distributed cache Cache Entry<tR+M2n5wIwzI=bqt2@teiid-security> params:null sql:select * from SmallA This displays the subsequent times the same query is run and you will not see source queries: 2013-10-18 07:19:21,115 TRACE [org.teiid.PROCESSOR] Cache hit for Cache Entry<tR+M2n5wIwzI=bqt2@teiid-security> params:null sql:select * from SmallA But if I remove the connection string and just try using the Cache Hint /*+ cache*/ you see nothing in the logs in regards to the Cache loading or being used on the second query, you still see Teiid pulling the results from the source. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira