Why does it sometimes take longer to activate cheats?

The time it takes to activate certain cheats hinges on a variety of factors but mostly boils down to the speed of your local RAM as well as the game's internal code/engine.