I know that when using a multi socket motherboard, the normal rule is to use several times the same cpu model.
But a split appeared in recent years which reached Intel: cpu which delivers more total performance does it at the expense of reducing per thread performance which penalize single thread workloads (where the computer does only one single threaded task one taking full ram).
So my idea is mixing the 2: taking a cpu which delivers good per thread performance and a different model still compatible with the same motherboard and a different one for delivering more performance for workloads which can run in parallel. In my case this means https://ark.intel.com/content/www/us/en/ark/compare.html?productIds=202780,192472
But in general, how to determine compatibility between cpu when both are compatible with the motherboard?