[teiid-issues] [JBoss JIRA] (TEIID-226) Cacheing translated commands would improve connector performance

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-226:
--------------------------------------

Looked into this again with embedded performance with spring boot.  The long-run overhead was negligible.

> Cacheing translated commands would improve connector performance
> ----------------------------------------------------------------
>
>                 Key: TEIID-226
>                 URL: https://issues.jboss.org/browse/TEIID-226
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Connector API, Query Engine
>    Affects Versions: 6.0.0
>            Reporter: Steven Hawkins
>             Fix For: 11.x
>
>
> Defect Tracker #16722: AD 2/17/05 - Command translation in connector - approx. half the time taken to create an Execution object is spent in command translation. If there was a way to cache the translated command, then we could eliminate that step for subsequent requests.
> Alex 2/17/05 - The problem is that the connector can be used with different vdbs, so the translation may be different even for the same query.  Still seems do-able [...].



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)