Normally 4 is optimal for me, the max I do is 8 tables but this is depending on what type of games I am playing.
I find when playing too many tables your decisions become robotic and you miss opportunities to pick up on little things that may help you with a decision.