[ https://issues.jboss.org/browse/TEIID-2584?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-2584: ------------------------------------- I was going to add, stop running the "start" triggers always by adding "isStartInProgress" call, thus making them symmetric. About Status table memory resident, we can do that when the contents are survive a node/cluster restart, otherwise we could have done that now. Since the query is in "wait" mode anyways it did not concern me that we are making another database call. Since "load" and "update" calls are not part of the user query, and matview updates are to the single source "XA" transactions should not be concern right? Especially when we introduce the separate connection for execution of these calls. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira