You can translate the question and the replies:

What is the optimal concurrency level for scheduling a job in scheduler to load cache for multiple views?

I want to schedule a job in the scheduler to load the cache for views on a daily basis. There are approximately 400 views and I have divided these views in 6 different jobs. These view are not equally distrributed. I want to know optimal concurrency level for scheduling a job in scheduler to load multiple cache simultaneously in less time and at the same time we don't get thread time out error because of the high concurrency level. Thanks.
10-09-2021 05:19:24 -0400

1 Answer

Hi, In situations where there is more than one load process configured for a VDPCache job, I would provide the Concurrency Level equal to how many load processes are configured. Generally, the "Concurrency Level" parameter in the CacheJob's Extraction section defines the load processes concurrency, meaning how many cache processes will be executed in parallel. The optimal number for this Concurrency level would depend on the use case. For instance, if there are 6 load processes I would specify the Concurrency Level as 6. The default value for the Concurrency Level would be 1. You can take a look at the [VDPCache Extraction Section](,Concurrency,-Level) of the Scheduler Administration Guide for more information. Suppose if you still need help and if you are a valid support user then you can raise a support case on [Denodo Support Site]( so that our support team can help you Hope this helps!
Denodo Team
13-09-2021 08:08:57 -0400
You must sign in to add an answer. If you do not have an account, you can register here