Translation of MySQL data in 6 different language

[sutharalpesh]

I have 20K record in 1 Table of MySQL DB

This table is having a Description column and 6 different columns as TLang1, TLang2, Tlang3....

I have to translate the data in Description column in 6 Different Languages and insert them in TLang1, TLang2, Tlang3.... columns in the same row.

What approach I can use to do this since the current approach is taking too long.

[josegutierrez]

What is your current approach?

[sutharalpesh]

I am taking 1 row at a time and calling the translate API 6 times to get 6 different text translations and then updating the row.

[josegutierrez]

You could do a Program that uses a Loop to translate each record and keep it in a Dataframe and then update the fields or replace the Table. There could be a case that you'll need to do this by parts by the Limits that Translation API have.