]
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 [...].