[teiid-issues] [JBoss JIRA] Resolved: (TEIID-1225) Reuse procedure plans

[Steve Hawkins (JIRA)]

     [ https://jira.jboss.org/browse/TEIID-1225?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

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