c2c-oerpscenario team mailing list archive

[xrg <xrg@xxxxxxxxx>]

On Tuesday 02 November 2010, you wrote:
> Public bug reported:
> 
> this 2 indices should improve performance if a lot of translations are
> to be processed.
> 
>     "ir_translation_ltnr" btree (name, lang, type, res_id)
>     "ir_translation_ltns" btree (name, lang, type, src)
> 

Well, I guess that /adding res_id/ as the 4th column to the (lang, type, name) 
index (partial matching will still work for the 3 first columns) may make some 
sense.

But, for "src" matching, I would like to see if 4-column _hash_ mapping will 
deliver its promises. Do you have any results?

-- 
[6.0RC1] performance 
https://bugs.launchpad.net/bugs/669919
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.

Status in OpenObject Server: New

Bug description:
this 2 indices should improve performance if a lot of translations are to be processed.

    "ir_translation_ltnr" btree (name, lang, type, res_id)
    "ir_translation_ltns" btree (name, lang, type, src)


currently defined only:
 "ir_translation_ltn" btree (name, lang, type)