You're right it will consume more memory, but most of this memory is shared (well, in *nix land it is, even in some OSes have problems reporting shared memory).
You can reduce the number of apache children (and db connections) you need per application by running a simple lightweight proxy in front.
-- More people are killed every year by pigs than by sharks, which shows you how good we are at evaluating risk. -- Bruce Schneier