[teiid-issues] [JBoss JIRA] (TEIID-2981) Add an OData query parameter that caches the resultset

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2981?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12972983#comment-12972983 ] 

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)