This Friday May 4th 2018, Odoo consultants were present at the Odoo Road show in Hotel Le Meridien – Jakarta. An opportunity for you to discover the new features of Odoo 11 and meet our team. We wanted to thank you for your visit.
[…] Read more
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
Big data Odoo optimization is a very serious issue indeed. Because Odoo can be provided to big companies, this also implies that they will use the system extensively and that goes in pairs with a very fast and sustained data growth. Obviously, the most impacted standard tables will be the ones we call the “_lines” tables such as: sales_order_line ; account_move_line ; stock_move_line etc….etc….
The issue
To evaluate the impact of generic data growth on these tables, let’s imagine a standard company with 10 branches and 2 accounting persons validating 100 invoices each per open day. Let’s be fair and set the […] Read more
Odoo virtual memory on VM is a critical issue. Why? Although datacnters are now thriving with VM instances, one has to keep in mind that Odoo was originally designed to be implemented on physical systems. Among the main differences, one must keep in mind that all VMs (Virtual Machines), droplets, instances and other emulated environments do not use any swap partition at all. And yet, SWAP is the guardian of stability when your environment starts falling short on memory…
As you can see, VM performanc is affected by the type of swap. Yet, absence of swap can be lethal to system […] Read more
Odoo security with Fail2ban is the result of my collaboration with Cyril Jacquier to the Fail2ban project. Through my implementations and throughout the life-cycle of an Odoo system, I have been confronted like so many system administrators with login attacks. Since Odoo is an online web-based ERP, nothing is easier than injecting POST requests and try to penetrate the system by brute-forcing the Login Interface.
As a result, I turned to Fail2Ban in order to parse the logs and ban from the NAT of the Odoo server the nasty IPs that kept sucking out bandwisth and CPU and compromising our client’s […] Read more
Last week, we recived the following enquiry:
We are an odoo official partner and we are interested to have a right technical implementation more secure and with performance for odoo.
How you can help us.
What we search is a Document or a user manual to configure and setup odoo and secure it.
And here is our reply, since this is something you should do before installing Odoo :
To be honest with you, I have been implementing data management infrastructures for almost 2 decades now and I am still learning every day. One thing you must understand about Odoo is that it is using […] Read more
Odoo better than Microsoft Dynamics or SAP? Why?
There are many reasons why Odoo is becoming the number one downloaded, implemented and used ERP platform in the world. Whether it is from the functional or technical point of view, here are the reasons why Odoo better than Microsoft Dynamics or SAP;
Real time process – it can be accessed everywhere at any time due to its web based interface
Faster communication. Because it can be accessed from anywhere, it makes communication faster within the departments.
No special hardware and no installation. You can start entryingyour data into the software from any computer as long as […] Read more
Odoo and PostgreSQL 9.5: a good or a bad idea?
After weeks of testing and benching Odoo and PostgreSQL 9.5, we have come to the following conclusion: PostgreSQL 9.5 (which comes out of the box with new Ubuntu 16.04 LTS) gives an excellent stability and performance.
Nevertheless, the PostGreSQL was slightly mofidied and some parameters we used to tweak in the previous version are now purely and simply gone. Others on the other hand have been added.
For example, checkpoint_segments is no longer being used and should be removed from the configuration.
On the other hand, max_wal_size has been added and shoud be setup […] Read more
Is Odoo 9 community enough out of the box?
Odoo 9 comunity is still new on the market and following 8, which end up being an excellent platform. But what are the major differences between 8 and 9?
Layer
Community v9
Enterprise v9
Required hardware
from 2 CPU / 2 RAM
from 2 CPU / 2 RAM
Scalability
The same load balancing
The same load balancing
Flexibility
The same modular architecture
The same modular architecture
Community and Store Apps
Can install any module
Can install any module
Enterprise Apps
Not available
Included in the package
Localizations
The same localizations
The same localizations
Out-of-the-box*
Requires more customization
Includes nice UI and more functionality
Access Rights
The same configuration
The same configuration
UI
Standard interface
Nice and fast navigation
Support and Upgrades
Not included
Included by […] Read more
Odoo FIFO LIFO : which system will fit your inventory and warehouse?
“Too much of a good thing can be wonderful.”
Mae West
Odoo FIFO LIFO possibility is a crucual point. Great logistics help your company to edge out the competition. It’s all about making sure your products are in the right place at the right time so your company is the one customers flock to. Warehouses may not seem like the most important or glamorous places, but warehouse management is the backbone of logistics. And, you may not have given it much thought, but […] Read more