Kevin: res.partner name_search has some drawbacks. Among others it will break the search if you are trying to show the name of a partner assigned to a company you have restricted access (a nightmare on multicompany setups) In all relations, access rules are applied to the access to the record, but you always can see the name of the record (many2one or many2many relationships). In the case of res.partner, name_search uses the current user access profile to get the name, and that fails if you have no access. Additionally, it makes a complex processing in case of contacts of companies, where record by record parents are accessed on sequential recursive functions. With 54K partners, it will be noticeable. A serious rework it is needed. In V7, you can see name_get function on line 538, at res_partner.py on server/openerp/addons/base/ Best regards
Gustavo Adrian Marino Mobile: +54 911 5498 2515 Email: [email protected] Skype: gustavo.adrian.marino 2014-02-11 18:19 GMT-03:00 Kevin Dennis <[email protected]>: > When I attempt to use the search field with the default 'Customers' filter > under Sales-> Customers, it takes over 15 minutes and no results are > returned (NOTE: we have 54K customers records). If I use 'Advanced Search' > under the pull-down menu and select 'Name' the results are immediate. Is > this expected behavior? > > I am using OpenERP v7.0-20140113-182049. > > Thanks, > > *Kevin Dennis* > Director of IT > eTech Parts LLC > 19937 W 162nd St. > Olathe, KS 66062 > www.etechparts.com > (913) 839-1718 Office > (913) 324-1544 Fax > > _______________________________________________ > Mailing list: https://launchpad.net/~openerp-community > Post to : [email protected] > Unsubscribe : https://launchpad.net/~openerp-community > More help : https://help.launchpad.net/ListHelp > >
<<inline: etech_logo.jpg>>
_______________________________________________ Mailing list: https://launchpad.net/~openerp-community Post to : [email protected] Unsubscribe : https://launchpad.net/~openerp-community More help : https://help.launchpad.net/ListHelp
