How do I Store / Access Translations Efficiently?

Posted by Gilbert on Stack Overflow See other posts from Stack Overflow or by Gilbert
Published on 2009-05-21T22:42:09Z Indexed on 2010/04/14 14:03 UTC
Read the original article Hit count: 281

Filed under:

database

|

internationalization

I am trying to translate some of the phrases of my website into various languages. so, in my database, I have a table with rows of

ID//text//dest_language//text_in_dest_language

At the moment, I retreive each translation one by one:

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

This results in 40-50 db calls per page, which, on the app engine, is rather slow.

What can I do to mitigate this slowdown?

© Stack Overflow or respective owner

Related posts about database

SQL SERVER Retrieve and Explore Database Backup without Restoring Database Idera virtual database

as seen on Dot net Slackers - Search for 'Dot net Slackers'
I recently downloaded Ideras SQL virtual database, and tested it. There are a few things about this tool which caught my attention.My ScenarioIt is quite common in real life that sometimes observing or retrieving older data is necessary; however, it had changed as time passed by. The full database… >>> More
Cloning A Database On The Same Server Using Rman Duplicate From Active Database

as seen on Oracle Blogs - Search for 'Oracle Blogs'
To clone a database using Rman we used to require an existing Rman backup, on 11g we can clone databases using the "from active" database option. In this case we do not require an existing backup, the active datafiles will be used as the source for the clone. In order to clone with the source database… >>> More
cPickle ImportError: No module named multiarray

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I'm using cPickle to save my Database into file. The code looks like that: def Save_DataBase(): import cPickle from scipy import * from numpy import * a=Results.VersionName #filename='D:/results/'+a[a.find('/')+1:-a.find('/')-2]+Results.AssType[:3]+str(random.randint(0,100))+Results.Distribution+"… >>> More
SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot

as seen on SQL Authority - Search for 'SQL Authority'
Snapshot database is one of the most interesting concepts that I have used at some places recently. Here is a quick definition of the subject from Book On Line: A Database Snapshot is a read-only, static view of a database (the source database). Multiple snapshots can exist on a source database and… >>> More
OTN ???? ?????? ???????

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Database ?? Database ??????? Database ?????????? Java WebLogic Server/????????·???? SOA/BPM/????? ???????/???? ID??/?????? ?????EPM/BI EPM/BI ??????? EPM/BI ???? OS/??? ???? ????? MySQL Database ?? ???? ?? ????????? ??? ?? ORACLE MASTER… >>> More

Related posts about internationalization

GWT Internationalization throws an exception while rebinding

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to internationalize a test application with GWT following the instruction and I have: com.example.client.MyConstants.java com.example.client.MyConstants_en.properties com.example.client.MyConstants_fr.properties com.example.client.MyAppEntryPoint.java In this code I have: public interface… >>> More
Please help with my JSP Internationalization problem

as seen on Stack Overflow - Search for 'Stack Overflow'
I have problem with I18N in JSP, specifically, with forms. When I enter some Czech characters (e.g., "ešcržýá...") into my page one form, into the field "fieldOne", and then show text from that field on page two, instead of Czech characters I see this as "ÄÄ". (Note, the second page gets the Czech… >>> More
Internationalization in a website

as seen on Stack Overflow - Search for 'Stack Overflow'
Dear All, I m using ResourceBundle method getBundle(Propertyfilename,Local.languagename) class which returns an object of ResourceBundle of the local rb = ResourceBundle.get Bundle("Locale Strings", Locale.ARABIC);-Not Supported How can i use this to support arabic,band english. >>> More
Internationalization of non-english application

as seen on Programmers - Search for 'Programmers'
I know there are lots of posts for internationalization, but this is something I didn't found while searching. I have a PHP Web application, which is pretty big right now. It's developed actively for 4 years and wasn't built with internationalization in mind. Text is everywhere - in plain HTML, in… >>> More
why Internationalization is shortened to "i18n" ?

as seen on Stack Overflow - Search for 'Stack Overflow'
When people discuss about Internationalization they use the word i18n more often. For first time I didnt get what they are referring at by i18n, then I came to know that its internationalization. So wanted to know how internationalization = i18n? >>> More