Sorry, we're using MySQL - should have specified. Thanks for all the tips so far. We're definitely exploring all caching options. Any suggestions for database

Sorry, we're using MySQL - should have specified. Thanks for all the tips so far. We're definitely exploring all caching options. Any suggestions for database load balancing/building out the DB farm? What about database sizes - we're probably adding 10,000 records a day. Thinking about using Amazon WS for storing all old data.