I want to build a php multilingual site. Let's say I want 3 languages for the beggining and then a smart way to add new languages when it needed.
Database VS Language files.
As I know there is two options.
1) I can use database tables with languages, translations, etc and every time based on user preferred language to retrieve data from the db which means lots of database requests.
2) I can use extrernal language php files with define (like some e-commerce frameworks who has different languages files into a language folder such us fr.php eng.php etc)
I want opinions about what is better using the following arguments.
1) Best performance
2) More flexible
3) More efficient
4) Intelligent way
Thanks in advance