Bug 869084 - [WebTrans] Too slow to load a big document that has >7000 text flows
Summary: [WebTrans] Too slow to load a big document that has >7000 text flows
Alias: None
Product: Zanata
Classification: Retired
Component: Performance
Version: development
Hardware: Unspecified
OS: Unspecified
Target Milestone: ---
: 2.0
Assignee: Patrick Huang
QA Contact: Ding-Yi Chen
Depends On:
TreeView+ depends on / blocked
Reported: 2012-10-23 01:56 UTC by Ding-Yi Chen
Modified: 2012-11-07 06:18 UTC (History)
2 users (show)

Fixed In Version: 1.8.0-SNAPSHOT (20121025-0030)
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2012-11-07 06:18:59 UTC

Attachments (Terms of Use)

System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 743179 0 unspecified CLOSED Too slow to load the document list of a big project with 1000+ documents 2021-02-22 00:41:40 UTC

Internal Links: 743179

Description Ding-Yi Chen 2012-10-23 01:56:01 UTC
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)

How reproducible:

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
Actual results:
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.

Expected results:
Loading is done within 30 seconds

Additional info:
Once it finish loading, the responding time for editing and page switching  are normal.

Comment 1 Patrick Huang 2012-10-24 00:21:00 UTC
committed into master:

reduced load time from several minutes to less than 1 second

Comment 2 Ding-Yi Chen 2012-10-24 23:28:52 UTC
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.

Comment 3 Sean Flanigan 2012-11-07 06:18:59 UTC
Fix released in Zanata 2.0.

Note You need to log in before you can comment on or make changes to this bug.