openerp-community team mailing list archive

["Fabrice Henrion" <fhe@xxxxxxxxxxx>]

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:openerp-community-bounces+fhe=openerp.com@xxxxxxxxxxxxxxxxxxx] 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: gamarino@xxxxxxxxx

Skype: gustavo.adrian.marino

 

 

 

2014-02-11 18:19 GMT-03:00 Kevin Dennis <kldennis@xxxxxxxxxxxxx>:

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     : openerp-community@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~openerp-community
More help   : https://help.launchpad.net/ListHelp