What is fastest?

Classic Servoy
1

Hi,
please check diagram first…before reading.

What I’d like to do is whenever I create a product, it automatically generates the product descriptions according to the languages. That’s not too dificult. Also when I create a language-record, the product descriptions should be creations according to the products.
Example:
200 products and 2 languages.
If I create a language there should be 200 product descriptions created
If I create a product there should be 2 product descriptions created (only a record with products_id)

Like I said that should not be a problem. But I wonder what is the quickest way to accomplish this.
Suppose you have 3000 products and you want to create an additional language.
I.e. is there a quick way to capture all products_id and then use them to create records in the products_descriptions table.

2

I assume that creating a language is not something that happens very often. In that case you can just loop through products and create a description for each product. Also: are you sure you want to pre-translate them? ie. why don’t you create the records at the moment they are being translated.