c2c-oerpscenario team mailing list archive

["Olivier Dony \(OpenERP\)" <610832@xxxxxxxxxxxxxxxxxx>]

Hello,

What about the sizes of the tables? Maybe your audit_trail tables were
much smaller than ir.model, so it may well explain why the overall times
is 1/3 for the same number of queries.

We are looking for ways to reduce the number of queries on ir.model in
the ORM, but the behavior you are reporting seems normal, and the
queries shown are the typical audit_trail ones.

** Changed in: openobject-server
       Status: New => Invalid

-- 
possible performance issue for ir_model
https://bugs.launchpad.net/bugs/610832
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: Invalid

Bug description:
Looking at the performance statistic generated with epqa I am puzzled to find the first query - which is very simple to be the one taking most of the time, almost the triple  of what the more complex query (3) needs.

Queries Took Most Time
Rank Total time Times executed Query
1  72.831  96131  SELECT ir_model.id FROM "ir_model" WHERE (ir_model.model=e{}) ORDER BY id
2  41.767  23111  commit
3  26.083  97360  SELECT audittrail_rule.id FROM "audittrail_rule" WHERE (audittrail_rule.object_id={}) AND (audittrail_rule.state=e{}) ORDER BY id

\d ir_model
...
Indexes:
    "ir_model_pkey" PRIMARY KEY, btree (id)
    "ir_model_model_index" btree (model)

any idea?