*idea* - Translation system *idea*

[eluser]Silviu[/eluser]

Well, the idea is not bad, but performance wise, you’ll suffer, just because of the database look-ups.

The idea is that for each and every string, there will be (at most) only one database search for every language. This means one search EVER, not one search per page load. Once the search is done, the string is properly written into a language file (cache) and on the next page load it will be read on from there.

This means that once you (as developer or owner) browse your site (without either a table or a cache file), entries are being added to the system, and it's enough to browse some pages to build the initial cache. Later on, only small performance hits will happen now and then, when a user encounters a string that was not displayed ever for anyone else until then.

When translating (using a proper admin/translation module) the language file/cache will be updated automatically with the database content.

What do you think it's the best option to implement it? A helper function? A model? What do we need?

Unfortunately I'm low on free time these days, as I have a personal project on my hands. And a baby girl. Two days old. YAY! :-)