← Back to team overview

openerp-india team mailing list archive

[Bug 821583] Re: many2one function fields are recomputed every time even with store=True

 

Hi,

How to avoid re-compute function fields with store = {} or store = True?
It affects performance too much. I rely on function fields for
synchronizing with other fields in other classes. And I also rely on
these stored values of function fields for doing sql query.

Currently I do some little trick to make syn between computed value and
stored value. However, I face performance issue too much. In my table,
it has about 150 records but it takes time about several seconds to
show. This is due to the function for function fields is rather heavy
processing.

So, please give me some ideas.

Thank you too much,

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Server.
https://bugs.launchpad.net/bugs/821583

Title:
  many2one function fields are recomputed every time even with
  store=True

Status in OpenERP Server:
  Confirmed

Bug description:
  Hi
  I am migrating my customer from v5 to v6
  I make some imporvement for is V6 and I have a problem with the function field

  I try to create a function fields with the type many2one and the
  option store=True. The problem is that the field is still read from
  the function and never from the database. It look like the option
  store=True is never use in reading.

  exemple add this field to sale_shop

      def _get_test_id(self, cr, uid, ids, name, args, context=None):
          print 'get test'
          res={}
          for id in ids:
              res[id] = 1
          return res

          'test': fields.function(_get_test_id, type='many2one',
                  relation='product.product', string='Product', method=True,
                  store=True),

  And open the sale shop. You will see that each time the sale_shop is
  open the field test is read from the function "_get_test_id" and not
  directly from the database.

  I have this bug with the last version of openerp 6.0

  I also send a mail to the support team.
  Best Regard

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-server/+bug/821583/+subscriptions