[teiid-issues] [JBoss JIRA] Commented: (TEIID-123) Staging tables performance appears to be sub-par
[
https://jira.jboss.org/browse/TEIID-123?page=com.atlassian.jira.plugin.sy...
]
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