I have 290K records in Sales>Customers and a default search takes 1 second. (and I go back and forth through a continent and the Atlantic to reach my server).
It sounds more like the problem comes from your infrastructure/DB configuration. __ Fabrice Henrion Director Americas OpenERP Inc. From: Openerp-community [mailto:[email protected]] On Behalf Of Gustavo Adrian Marino Sent: Tuesday, February 11, 2014 2:57 PM To: Kevin Dennis Cc: openerp-community Subject: Re: [Openerp-community] Customer Search 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 <http://www.etechparts.com/> 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
<<image001.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
