Architectural Decisions to Improve WordPress Performance

This tutorial has some good tips on query optimization and some data related things to consider when planning your project.