performance issue - missing indices for ir tables
Bug #572848 reported by
Ferdinand
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Odoo Server (MOVED TO GITHUB) |
Fix Released
|
Low
|
Unassigned | ||
Bug Description
see patch
in daily statistics
ranking / # executed
2 94433 SELECT id FROM ir_model_fields WHERE name=e{} AND model=e{}
3 93578 SELECT * FROM ir_model_fields WHERE model=e{} AND state=e{}
ranking 7 and 11 in slowest queries
ranking 3 and 8 in most time consuming
patch will solve this by creating indices
Related branches
Revision history for this message
| Ferdinand (office-chricar) wrote | #1 |
Revision history for this message
| Olivier Dony (Odoo) (odo-openerp) wrote | #2 |
| Changed in openobject-server: | |
| importance: | Undecided → Low |
| milestone: | none → 6.0 |
| status: | New → Fix Released |
To post a comment you must log in.
Thanks for taking the time to report this and for the patch.
Merged in revision 2472 on trunk (<email address hidden>)
We might have to add some combined indices if this makes a big difference.