Elacticube build - Level of parallelism | Product Feedback Forum

fschleich · 2023-09-15T07:41:06.792000Z

Hello,How about having a better control over queries parallelism ?My use case :Elasticubes using 2 connections : DB1 / DB2Currently, 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.

MoreDiscussions

Elacticube build - Level of parallelism | Product Feedback Forum | Sisense Community