Odoo data size limits

Following this past years of Odoo Implementation, we had the opportunity to consult with many large clients whose data has now grown beyond expectation…. and we had to handle Odoo data size limits.From the Odoo perspective, expansion of database size is most of the time always hitting the same tables in Sales, Stock and Invoicing as well as Accounting. This is aggravated by the following facts:

All detail lines including in Acconting are per product.Perpetual costing implies a large number of stock moves since every transaction is tracked per product as well.

According to the business size and the amount of transactions, the […] Read more

Odoo performance with 8, 9, 10 & 11 and PostgreSQL 9.6

With the arrival of PostgreSQL 9,6, Odoo performance can now benefit from parallel query functions. From the PostgreSQL side, this is excellent news because this means many SELECT queries operated by the Odoo ORM can be run faster than they used to be. On the paper, the advantages are:

Faster query results (PostgreSQL claim up to 32x faster than on previous versions such as 9.5)
Improvement in GIN, BRIN and B-tree Indexing modes.
Better Row compression

Yet, when one looks at Odoo performance, one must understand that Odoo does not have capacity to use these very efficiently since the above imply two major factors […] Read more