[
https://issues.jboss.org/browse/TEIID-1474?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1474:
---------------------------------------
After more thought, my initial approach would be to add a setting to limit the source
concurrency of all user requests.
By default it would be set to something like min(maxThreads, max(4,
2*maxThreads/maxActivePlans))
Having it at 1 would execute the request serially, just like when transactional.
Add query hint to limit parallel execution of union members
-----------------------------------------------------------
Key: TEIID-1474
URL:
https://issues.jboss.org/browse/TEIID-1474
Project: Teiid
Issue Type: Feature Request
Reporter: Howard Abrams
Assignee: Steven Hawkins
We would like a new query hint to limit the number of parallel executions of union
members. This is useful in two situations:
1. When the queries are expensive, but the overall union contains a limit that is most
likely to be fulfilled by the first member of the union
2. When the queries are backed by a common resource which may be overloaded by multiple
queries
The addition of a hint would make this manageable by the client; perhaps something like
"/*+ parallel=2*/"?
--
This message is automatically generated by JIRA.
For more information on JIRA, see:
http://www.atlassian.com/software/jira