Let $ R $ be a commutative unital ring, $ I $ an ideal of $ R $, and $ M $ an $ R $-module. The cohomological dimension of $ M $ with respect to $ I $ is defined as $$ \operatorname{cd}(I,M) \stackrel{\text{def}}{=} \sup(\{ i \in \mathbb{N} \mid {H_{I}^{i}}(M) \neq 0 \}). $$ From the fact that $ \operatorname{cd}(I,M) \leq \operatorname{cd}(I,R) $, one guesses that there is a relationship between cohomological dimension and the support of modules such as: $$ \operatorname{supp}(M) \subseteq \operatorname{supp}(N) \iff \operatorname{cd}(I,M) \leq \operatorname{cd}(I,N). $$
Can anyone prove this relationship or give a counterexample, please? You can add any assumption that helps, such as ‘being local’.
The closest result that I can find is the following:
The reference is K. Divaani-Aazar, R. Naghipour and M. Tousi, Cohomological Dimension of Certain Algebraic Varieties, Proc. Amer. Math. Soc. 130 (2002), 3537-3544.