c2c-oerpscenario team mailing list archive

["Ferdinand @ ChriCar" <669919@xxxxxxxxxxxxxxxxxx>]

@Albert
If I understand correctly your patch drops the index
"ir_translation_ltn" btree (name, lang, type)
how will this query perform ?
Times Query
4044	SELECT value FROM ir_translation WHERE lang=e{} AND type in (e{}) AND name=e{}

-- 
[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)