[
https://jira.jboss.org/browse/TEIID-1225?page=com.atlassian.jira.plugin.s...
]
Steve Hawkins resolved TEIID-1225.
----------------------------------
Resolution: Done
Changed storedprocedure planning to reuse procedure plans. This required that the
QueryOptimizer perform both the rewrite and the optimize for CreateUpdateProcedureCommands
to properly detect the determinism level. The resulting plans are stored in the
preparedplan cache. We'll need to investigate whether it makes sense to increase the
default size. The plans could be stored in a more compact manner though since child plans
are cloned into parents. It would be better to defer the clone or defer the planning.
Reuse procedure plans
---------------------
Key: TEIID-1225
URL:
https://jira.jboss.org/browse/TEIID-1225
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Affects Versions: 7.1
Reporter: Steve Hawkins
Assignee: Steve Hawkins
Fix For: 7.1.1
Stored procedure plans should be reused as much as possible - not just if the client is
using a prepared statement.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira