I am trying to find out the best way to localize my Schema.
I have a database schema with large number off tables that need to be localized to unknown number off languages.
The problem is, that i want the localization to be, simple to managed and have the best performance has possible.
The way i look at it i have two ways:
1) Localized each table separately. 1 Localized table for each data table - good for performance but difficult to managed.
2) Localized each column separately. 1 Localized table for all data table good to managed But poor on performance.
Does any one have some tips for the right approach, or knows of a good Artical or "Best practice" for localization?