Community mailing list archives
Re: architecture question on invoice payment V8by
Skillteam, Houssine BAKKALI
it comes from the account.move and account.move.line that are generatedYou may want to join/follow this interresting discussion initiated by Sebastien Beau from akretion.
You could found some hints to solve your issue
2016-01-15 5:47 GMT+01:00 OpenERP Master <email@example.com>:
Please let me know any details requested.Without taking apart line by line, my first assumption is because the system is using very inefficient SQL queries or careless for loops within for loops. IMO this really can affect the scalability of the software if you reach a certain level of paying invoices per day.Can an expert, not a jr dev, give me some insight on what is known about why this process takes so long, and are there any python methods that can be improved to fix this performance problem.Another example, I can import 100,000 sales orders one by one in a day with very complex query, but I couldn't pay those orders in under a week. I could deliver all of them by using force assign and it still run 2-3x faster.Paying an invoice is dog slow, even in a fresh database with not more than thousands of records. I can create thousands of sales orders with thousands of sql queries and complex searching, but if you want to pay (proforma_invoice) an invoice, it takes several seconds per document.Hello,Generally Odoo is pretty speedy, I can create sales orders, do delivery, check/force availability, etc pretty quickly.