openerp-expert-framework team mailing list archive

[Alexandre Fayolle <alexandre.fayolle@xxxxxxxxxxxxxx>]

On mer. 16 avril 2014 15:34:23 CEST, Florent wrote:
> Alexandre,
>
> Actually, we did the same analysis some time ago when looking for
> easy-wins on our project, and I've added a small script which is
> called after each OpenERP refresh ( >>> client.upgrade("base") ) to
> check if some index is missing.
> We've seen big improvements on database usage, especially when
> deleting entries in heavy tables having foreign keys.
>
> https://gist.github.com/florentx/10875212
>
>

If this is so, maybe this behaviour could be considered as part of v8 ?

I'm also wondering about having hash indexes on selection fields.

--
Alexandre Fayolle
Chef de Projet
Tel : + 33 (0)4 79 26 57 94

Camptocamp France SAS
Savoie Technolac, BP 352
73377 Le Bourget du Lac Cedex
http://www.camptocamp.com