many2many_tags performance problem due to series of name_get call

[Mohammed Shekha(Open ERP)]

Hello,

I faced the issue with many2many_tags widget, there is issue of performance due to series of name_get calls, when there is a many2many_tags widget in list view.

Steps to produce: Create a 80 to 90 records in a listview where there is a many2many_tags widget available, say for example take a Sale Order Line create 80 to 90 records for Sale Order Line, after creation just open or edit that Sale Order record you will notice many2many_tags takes time to load, you will also see record is loading...

The reason is simply design of many2many_tags, many2many field calls name_get for each record of sale order line, so if there are 80 records in list then 80 name_get calls goes to fetch name for many2many_tags and it creates performance issue.

For now I do not have any solution suggestion from web-client because when we edit or Save the record record is reloaded by design, I am not sure but it should be fixed from server same as many2one sends return value in format (id, value), we should return value for many2many field in format [(id, value), (ids, value)...], I am not sure this is the only way but I think this way name_get will not be needed anymore after this, we also need to change the many2many and many2many_tags widget to deal with such values.

Thanks.

[Florent THOMAS (mailinglist)]

Hy
Additionnaly, this performance issues causes me some troubles behind proxies :
* https://bugs.launchpad.net/openerp-web/+bug/1217735
* http://help.openerp.com/question/29281/v7-and-proxy-mode-failed-on-partner-list/

[Mohammad Alhashash (alhashash)]

The same issue applies for 'reference' fields. The client calls name_get for each record.