Thanks, will check it out. So, what you suggest is that if I have 40 small inputs that I would like to consolidate, it is better to make 4 transaction each with 10 inputs and 1 output?
No. An input is roughly 68vbytes and 10 inputs would be only 680vbytes (0.68vKB). The limit for the transaction to be considered standard is 400,000 weight units or 100,000vBytes. What he meant was that splitting your (presumably large) consolidation into multiple of them would give the transaction a better chance to be fit into a block. Ie, Having a 10KB transaction when the miner can only fit 9KB left, the miner could possibly choose to include other transaction so the space is optimized.
I don't think there is any harm to have a larger transaction as long as it's under 100vKB and you have flagged it as opt-in RBF so it's easily replaceable if needed.