[teiid-issues] [JBoss JIRA] (TEIID-3434) Ability to enable/disable caching by table and/or source
[
https://issues.jboss.org/browse/TEIID-3434?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-3434:
---------------------------------------
Added the extension property teiid_rel:data-ttl that will be examined for each
table/source contributing to result set cache entry. The least non-zero entry will be
used as the ttl (or the lesser or the cache hint ttl). A zero value indicates that
entries accessing that table/source should not be cached.
An issue with this approach is that we don't have in ddl a way to set a property on
the schema (I'm not sure if designer will allow that either, but the current index
metadata logic supports it). We also have model properties that fill the same role. So
for this to work at a schema level may require a new ddl construct.
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
Fix For: 8.11
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)