[teiid-issues] [JBoss JIRA] Commented: (TEIID-123) Staging tables performance appears to be sub-par

[Steve Hawkins (JIRA)]

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

Steve Hawkins commented on TEIID-123:
-------------------------------------

Temporary tables can now have primary keys, which could address some of the problems - if staging tables/mapping classes are allowed in the designer to set primary keys.  

> Staging tables performance appears to be sub-par
> ------------------------------------------------
>
>                 Key: TEIID-123
>                 URL: https://jira.jboss.org/browse/TEIID-123
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 8.x
>            Reporter: Steven Hawkins
>             Fix For: 8.x
>
>
> Defect Tracker #20207: While working on the E2E Staging Tables Test Script, Mark Donnelly noticed the performance was fairly even between docs using staging tables and docs not using staging tables. I did further research and found the queries ran faster without staging tables. The email thread is attached (zipped in case the Trakka doesn't like it).
> The Model Project Set is also attached. The VDB's lone binding is defined.

-- 
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