My web application is implemented in Grails.
My situation is that I have a domain class (hibernate class) with more columns and some of them are large Strings, up to 4000 characters.
For example :
String description // max 4000
// column2, column3, etc
Now I have to implement a multiple language database for this elements and my strategy is to have one field for every language.
String description_en_US
String description_de_DE
My question is if it is more efficient if I have a separate table for every language, or to save it in one large table. The question has two parts. First, which is more efficient for hibernate if it uses a large memory when loading the data and second, which is more efficient for the database?
It can happen that later I'll have more than 10 languages.