[teiid-issues] [JBoss JIRA] (TEIID-3434) Ability to enable/disable caching by table and/or source

[Ramesh Reddy (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3434?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13059382#comment-13059382 ] 

Ramesh Reddy commented on TEIID-3434:
-------------------------------------

Yes, but they are two different things. PreparedPlan caching will get you statement cached, but it will execute every time. For resultset caching, you need to specify the /*+ cache */ hint in your user query then results will cached for specified time and scope(user, session or VDB).

> Ability to enable/disable caching by table and/or source
> --------------------------------------------------------
>
>                 Key: TEIID-3434
>                 URL: https://issues.jboss.org/browse/TEIID-3434
>             Project: Teiid
>          Issue Type: Feature Request
>            Reporter: Burak Serdar
>            Assignee: Steven Hawkins
>
> We need to be able to enable/disable caching by table and/or source. Some of our tables have real-time data, and we do not want to cache those, and some other tables can use cached data. It is not sufficient to use SQL options to turn caching on or off, because we're using 3rd party tools, and we don't have control over the SQL they generate.



--
This message was sent by Atlassian JIRA
(v6.3.11#6341)