I have a problem regarding a ir.cron task that runs by a bunch of assets and tries to post them automatically. Said method runs perfectly with 700 depreciation lines but when i take to production where are a considerable larger amount of assets and depreciation lines (558,747) the openerp-server just stops and falls down.
ids = self.search(cr, uid, [('state', '=', 'open')]) for asset in self.browse(cr, uid, ids): for asset_line in asset.depreciation_line_ids: if asset_line.move_check:
This code gets all my assets that are open and then try to check for a set of conditions and post it. When it gets to the asset_line.move_check line, it takes a long time and then it kills the proccess, all while keeping the server cpu at 100%.
Any ideas on how i can improve performance on this?
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 4/2/14, 5:13 PM|
|Seen: 1343 times|
|Last updated: 3/16/15, 8:10 AM|