Mysql optimization for large amounts of data

Question

I would like your opinions on the db scheme to be created. In db data from different languages ​​will be stored. The inserts will be around 30,000 to 50,000 daily, with heavy readings. I can have a total of 6 tables containing data for each language, or I can create 6 different tables for each language. Would the second option be more effective for heavy readings? What other methods do you offer to help system performance (data sharing, etc.)?

thanks

Answer 1

Perhaps this blog post might be helpful:

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

Oh and one more tip ... Do not use 6 tables!