Import process extremely slow with large number of keys and multiple languages

[digitalcraftlabs]

Hi,

I have a large number of translation keys (around 140,000) spread across different files. Since I have 12 languages, the total number of entries to import is multiplied (≈ 1.68 million).

The current import process is very slow because:

• Each key is inserted directly into the database one by one.
• Before inserting, multiple queries are executed for each key.

In our case, the import now takes around 3 hours to complete.

Is there any way to optimize the import process? For example:

• Bulk inserting translations instead of inserting per key.
• Reducing redundant queries during the process.

Any guidance or solution would be greatly appreciated.

Thanks in advance!