]
Steven Hawkins commented on TEIID-2981:
---------------------------------------
Would a first step enhancement be allow setting the ResultSetCacheMode on the connection
via the servlet init parameters or do you need fine grained control?
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)