> > 4) Nobody just tried to tune performance at least on central DB tables, by > adding some indexes. Although there is couple of indexes present, there are > no API functionality to add them, not consistent, so I see that somebody have > added them by a chance. I do not even talk about things that are beyond basic > DB functionality. >
That one is true. First thing I do after creating a new database for developing is to add some indexes like these: CREATE INDEX ir_model_data__module_model_id__index ON ir_model_data (module, model, id); CREATE INDEX ir_model_fields__model_state__index ON ir_model_fields (model, state); That make reloading modules faster (so you save time each time you need to test your module): SELECT ir_model_data.id FROM "ir_model_data" WHERE (ir_model_data.module IN (E'')) AND (ir_model_data.model IN (E'',E'',E'')) ORDER BY id; (run about 400 times when reloading modules) => goes from a total 1.8 seconds to 0.2 seconds. SELECT * FROM ir_model_fields WHERE model=E'' AND state=E''; (run about 800 times when reloading modules) => goes from 1.0 second to 0.3 seconds. That's more than 2 seconds saved each time you reload the addons or start the server. So it seems that there is some room for improvements on this side :) ------------------------ Borja López Soilán Pexego - www.pexego.es -------------------- m2f -------------------- -- http://www.openobject.com/forum/viewtopic.php?p=42640#42640 -------------------- m2f --------------------
_______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman2/listinfo/tinyerp-users
