mysql optimization for a lot of data

Question

I would like your opinions on a db schema I will be creating. The db will hold data from different languages. Daily the inserts will be around 30.000 - 50.000, with heavy reads. I can have just 6 tables holding the data for every language or I can create 6 different tables for each language. Will the second option be more efficient for heavy reads? What other techniques do you suggest, to help the system's performance (data partitioning etc)?

Thanks

Answer 1

Maybe this blog post might be useful:

http://20bits.com/articles/10-tips-for-optimizing-mysql-queries-that-dont-suck/

Oh yes and another tip... Don't use 6 tables!