openerp-community team mailing list archive

[Cloves Almeida <cjalmeida@xxxxxxxxx>]

A solution to give an order of magnitude performance speed would be:

a) create a "name_with_company" stored function field on res_partner to avoid the join;

b) create an expression index[1] on "lower(name_with_company)";

c) change the query to use ('lower(%s) like lower(name_with_company)') for ("name","ilike") name_search (about 99% of the case)

d) keep the self.search to apply the record rules - the IN on the database side is a cheap query.


[1] http://www.postgresql.org/docs/9.1/static/indexes-expressional.html
-- 
https://code.launchpad.net/~openerp-community/openobject-server/fix-1094212-multicompany-res_partner/+merge/141936
Your team OpenERP Community is subscribed to branch lp:~openerp-community/openobject-server/fix-1094212-multicompany-res_partner.