If you're saying that translations are done with a mysql database doing "select foreign.text from foreign natural join native where native.text = 'foo'", then I'd definitely like to talk to someone - you should be able to get better performance by using a specialised structure like a suffix tree, or better functionality by integerising each word and searching for strings of integers.
If you're saying that translations are done with a mysql database doing "select foreign.text from foreign natural join native where native.text = 'foo'", then I'd definitely like to talk to someone - you should be able to get better performance by using a specialised structure like a suffix tree, or better functionality by integerising each word and searching for strings of integers.