c2c-oerpscenario team mailing list archive

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

I used 
http://sourceforge.net/projects/epqa/

and it shows that ir_translation has a very high number of queries

I attach 2 statisitics to give you an idea 
installed demo data ~> almost no moves 
a problem seems account GL report (only one report tested) 
FROM "decimal_precision" is executed much to often.

Rank	Times
executed	Query
1	8820	SELECT value FROM ir_translation WHERE lang=e{} AND type in (e{}) AND name=e{} AND src=e{}
2	4044	SELECT value FROM ir_translation WHERE lang=e{} AND type in (e{}) AND name=e{}
3	2664	SELECT * FROM ir_model_fields WHERE model=e{} AND state=e{}
4	2664	SELECT id FROM ir_model_fields WHERE name=e{} AND model=e{}
5	2646	SELECT decimal_precision.digits,decimal_precision.name,decimal_precision.id FROM "decimal_precision" WHERE decimal_precision.id in ({}) ORDER BY id
6	2646	SELECT "decimal_precision".id FROM "decimal_precision" WHERE (decimal_precision.name=e{}) ORDER BY id


** Attachment added: "stat.zip"
   https://bugs.launchpad.net/openobject-server/+bug/669919/+attachment/1720838/+files/stat.zip

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