Big files (>1MB, >10k strings) are slow or even fail to sync

[readingsnail]

sometime, i handled 1mb+ files for pontoon translate.

almost times, this file(1mb+ and 10k+ columm) has not moved, but change file has very slowly or not changed. even dyno upgraded. like this files.

l_english.properties.zip

[mathjazz]

I recommend splitting strings into multiple files to improve performance. If you add or change 1 string in single-file project, the entire collection of strings (10k+ in your case) need to be checked for changes.

That said, we should still look into improving (DB) performance for bigger files.