]
Steven Hawkins updated TEIID-2981:
----------------------------------
Fix Version/s: 8.8
Will look at exposing more connection properties via the servlet config such that result
set caching or even autocommit txn mode can be set for odata.
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,
Fix For: 8.8
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)