Hello, Currently the number of queries running in parallel during an EC build is set at the server level. With setting "Build / Base Table Max Threads" (4 by default). The optimised number of simul...
Hi Dray,
Let me try to give you more details about eh option "Base tables Max Threads"
1. Current situation
The option "Base tables Max Threads" is set in the menu "System Configuration", hence the same for every cubes
2. My initial proposal :
Be able to define this value per cube. But I understand your concern about a risk of overload.
3. Alternate proposal #1 :
Be able to define it per Data Group. Having a new option "Base tables Max Threads" in this menu :
4. Alternate proposal #2 :
Be able to define it per Connector. Having a new option "Base tables Max Threads" in this menu :
=> My prefered alternate option is #2 (per connector)
Indeed, in makes sens to define the parallelism level per type of data source (ie : when accessing a standalone database is not the same as accessing a clustered database where we can increase the number of queries run in parallel)
What do you think ?
Kind regards,
Franck