Well, I have built a set of tables that run are meant to run with fewer joins, but I want to keep my normalized database around. Is there a way to switch between them when my site has a lot of traffic?
If it is in order to simplify your queries, you might want to create a view which in turn can bundle some joins.