Fix already merged in stable 6 at 5169:
[email protected]
Thanks,
Naresh
** Changed in: openobject-addons
Status: New => Fix Released
** Changed in: openobject-addons
Importance: Undecided => Medium
--
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/963031
Title:
mrp scheduler running very slow when there exists a lot of procurement
orders
Status in OpenERP Addons (modules):
Fix Released
Bug description:
when there are thounds of procurement orders, sorting on planed_date
make the search query extremly slow, and it is not necessary here.
Solution:
file modified: addons/procurement/schedulers.py
Removed date sorting and also added condition to get only procurement orders
in 'exceoption' state. commit for every 500 procurement order processed
- ids = procurement_obj.search(cr, uid, [],
order="date_planned")
- for id in ids:
+ ids = procurement_obj.search(cr, uid, [('state', '=',
'exception')])
+ qty_procs = len(ids)
+ for i, id in enumerate(ids):
wf_service.trg_validate(uid, 'procurement.order', id,
'button_restart', cr)
- if use_new_cursor:
- cr.commit()
+ if (((i+1)%500 == 0) or (qty_procs == (i+1))) and
use_new_cursor:
+ cr.commit()
To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/963031/+subscriptions
_______________________________________________
Mailing list: https://launchpad.net/~openerp-india
Post to : [email protected]
Unsubscribe : https://launchpad.net/~openerp-india
More help : https://help.launchpad.net/ListHelp
