As the title states, I’m wondering what would be the recommendation on the number of worker threads.
Are those threads only CPU-bound (by delegating the task to write on the disk to other threads) or do they perform themselves the I/O operations?
I’m asking this because in the former case I would assume a number close to the number of processors might be the best configuration. In the latter case, I would increase it (4 times the number of processors?).
Any suggestion is more than welcome!