[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=13059365#comment-13059365 ] 

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

Setting the "materialization=true" flag does what you looking for. Is that not sufficient? When you do not want to use cache you can always supply OPTION NOCACHE in the query. 

> 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)