How to efficiently and efficiently perform online translations?

Question

I am trying to translate some phrases on my site into different languages. so in my database i have a table with rows

ID // Text // dest_language // text_in_dest_language

At the moment I am returning each translation every time:

get text_in_dest_language where text = "Hello World" and dest_languge = "zh"

This results in 40-50 dB calls per page, which is quite slow in the application engine.

What can I do to reduce this slowdown?

0

Gilbert May 21 '09 at 22:42

1 answer

Cade roux · Answer 1 · 2009-05-21T22:46:37+0000

Load them at the application server level (in ASP.NET you can store it in an Application object or in a Session object).

or

Make one database call to get a single set of records for all phrases used on the page.