Unable to execute more than 10 concurrent source threads for a single query in JBoss Data Virtualization

Solution Unverified - Updated -

Issue

  • When we query against JDG with the example query with about 40K elements in the IN criteria, the query engine splits the query into 16 queries with 2500 elements in it. When it executes the query, a maximum of 6 threads concurrently execute the queries.

  • Based on the JDV documentation, the number of conccurrent threads used for execution on the source is based on the "thread-count-for-source-concurrency" configuration (if value is not 0) or 2 * (max-threads / max-active-plans).

  • We have tried increasing the number of "max-threads" to 1024 and setting the "thread-count-for-source-concurrency" configuration to 50, but the maximum number of threads that is used only increased to 10.

  • I feel like something is bounding this limit so it cannot use the max. Is there other configurations we can look at to increase the number of threads used ?

Environment

  • Red Hat JBoss Data Virtualization (DV) 6.1

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.