fschleich's avatar
09-15-2023
Status:
New Idea

Elacticube build - Level of parallelism

Hello,

How about having a better control over queries parallelism ?

My use case :

Elasticubes using 2 connections : DB1 / DB2

Currently, the parameter BaseTableMaxThreads (sets to 2 for us) controls how many queries can run in parallel, whatever the connection. During build, we frequently see situations where we have 1 query on DB1 and another one on DB2. Reducing the level of parallelism was necessary to limit contention on one connection but it would be fine to have 2 queries on DB1 and 2 queries on DB2 at the same time.

My proposal is the following : having a parameters to controls the level of parallelism per connection and not per build.

Thank you. 

 

No CommentsBe the first to comment