Tricks to Import Huge Amount of Data Into Odoo in Seconds
- 4.4
Brief Introduction
Regularly import million of external records FAST!Description
Do you have Odoo implementation cases to regularly import a huge amount of data from external data source like MS SQL, Oracle, MySQL, etc? I meant, very huge, like million of invoices or journal entries record per day ?
Using the common standard way, the Odoo's XMLRPC and ORM, this process can take hours, if not timeout, while we are taking a few cups of coffee as Odoo suggests :)
This course explains in detail about techniques to improve the data import performance, starting from data source query, processing in Python, and processing in Odoo Database (PostgreSQL) to achieve a drastic performance increase, that was previously taking more than 10 hours to only seconds! Yes, seconds.. how can it be ? Is that possible ?
YES
And we have implemented this technique in many implementation cases where Odoo's default mechanism is no more capable to handle that million of records per day!
Enjoy !
Requirements
- Requirements
- Odoo Addon Fundamental
- Odoo XMLRPC Fundamental
- Python Language
- SQL Fundamental