Sure they can. Put inefficient code on a super computer and it will quickly. If you write efficient code/queries, it will reduce the need for powerful servers. MW is one big database of a game, and there is obviously too much data and requests going into servers per user.
Also if code didn't change much but the player base decreased, what else do you blame for lag?