title: Database: A table for each language or one table with a language column
body: <p>I am creating a book database in mysql. One book can have different languages. And there is going to be many thousand books. (And I am far from a pro in this field, only created small and simple databases before)</p>
  
  <p>1) Is it fast enough to just create one table with a language column and create an index for it.
  2) Or will it be significantly faster to create a table for each language.</p>
  
  <p>My intuition (witch is not jet reliable in this field) tells me to go with the first option. I think it is more normalized to. It looks much cleaner and easier to extend to more languages. And it requires less programming. 
    However, it is mainly the English language that are going to be used (It will also be the larges collection), and will it not take more time to access those books when the table is filled books written in other languages? </p>
  
  <p>Speed is of some importance since it is going to be used on a website. But if there is no significant performance difference I prefer to chose the easy way.</p>
  
  <p>It will not be many different languages, 5 max 10, i guess.</p>