[
https://issues.jboss.org/browse/TEIID-2981?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-2981:
---------------------------------------
There are the other considerations that when paginated results are requested, we'll
automatically use result set caching and you may want consider using materialized views to
consolidate some of the caching logic to the server side rather than making clients too
aware.
Add an OData query parameter that caches the resultset
------------------------------------------------------
Key: TEIID-2981
URL:
https://issues.jboss.org/browse/TEIID-2981
Project: Teiid
Issue Type: Feature Request
Components: OData
Affects Versions: 8.7
Reporter: John Muller
Assignee: Steven Hawkins
Priority: Minor
Labels: Caching, OData,
The Teiid caching guide indicates that the /*+ cache */ SQL hint is neccessary in order
to cache results [1] . We would like two features added to the OData support: (1) to
have a query parameter that basically injects the hint into the SQL statement run against
the VDB and (2) a configuration setting that turns on OData resultset caching for all
result sets smaller than some size (perhaps 256 as the default)
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)