Bug 884335 - [RFE] Add Translation Memory Cache for filter query
Summary: [RFE] Add Translation Memory Cache for filter query
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Zanata
Classification: Retired
Component: Performance
Version: 2.0
Hardware: Unspecified
OS: Unspecified
unspecified
medium
Target Milestone: ---
: 2.1
Assignee: Carlos Munoz
QA Contact: Ding-Yi Chen
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2012-12-05 23:44 UTC by Carlos Munoz
Modified: 2013-02-26 04:06 UTC (History)
1 user (show)

Fixed In Version: 2.1-SNAPSHOT (20121206-1113)
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed: 2013-02-26 04:06:29 UTC
Embargoed:


Attachments (Terms of Use)

Description Carlos Munoz 2012-12-05 23:44:03 UTC
When using Text Flow lucene indexes, a database query needs to be used to filter out untranslated results. An updatable cache needs to be added so that this query is run the least possible number of times. This is an expensive query as it probably scans the whole table.

Comment 1 Carlos Munoz 2012-12-06 01:41:32 UTC
Added a Translation Memory helper component that caches the translated text flow ids for each locale. This cache is updated every time a translation occurs.

Testing Notes:
Test scenarios where a text flow target changes to all states (fuzzy, approved, not translated).

See:
https://github.com/zanata/zanata/commit/e937a9120ed977904995c56f898c62b47b6ed89b
https://github.com/zanata/zanata/commit/4b868b54b444fa2e2cf158f367ceddf0f8530cbd
https://github.com/zanata/zanata/commit/2fda4c7823a16b1a5e1b8c0effa7accd2ba193b8

Comment 3 Ding-Yi Chen 2012-12-10 03:29:29 UTC
VERIFIED with Zanata version 2.1-SNAPSHOT (20121206-1113)


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