Forum Moderators: buckworks
Slower as you get more traffic? Yes.
Can it be sped up? Yes.
How? Turn off cart statistics or move them to a separate database. Keep the orders db trimmed down to a minimum - theoretically this could also be moved to a separate database (I haven't tried this yet). Use a dedicated server with some form of script accelerator.