Description of problem:
It takes quite a long time to load a big document with many translation
The project I use is freeciv
whose translation can be found here:
This project have over 7200 text flows.
Version-Release number of selected component (if applicable):
Zanata version 1.8.0-SNAPSHOT (20121023-0030)
Steps to Reproduce:
0. Create project freeciv, version master if you have not.
1. Download the pl.po.bz2, zh_CN.po.bz2, zh_TW.po and freeciv.pot from
2. Unzip the bz2 files
3. Write a zanata.xml file which specifies that pl, zh_CN, zh_TW will be pushed
4. zanata push with translation.
5. Sign in to Zanata
6. Visit the pl, zh_CN, and zh_TW for freeciv
Google Chrome 15.0.874.121
pl polish translation:
Loading: 1:26 minute
(translated: 77899, fuzzy: 8230)
zh-CN Simpified Chinese translation:
Loading: 1:32 minute
(translated: 13127, fuzzy:20492)
zh-TW Traditional Chinese translation:
Loading: 1:20 minute
(translated: 6072, fuzzy:0)
Firefox is about the same.
And it seems that database backend does not matter, as H2 and MySQL roughly took the same amount of time.
Loading is done within 30 seconds
Once it finish loading, the responding time for editing and page switching are normal.
committed into master:
reduced load time from several minutes to less than 1 second
VERIFIED with Zanata version 1.8.0-SNAPSHOT (20121025-0030)
Now open the first page require 4 secs, and page switch now take about 3 seconds.
Fix released in Zanata 2.0.