The world is yours

T313 Teknik Mempercepat Odoo 1000x lebih cepat

Enroll Back

Penggunaan stored procedure dan function untuk mempercepat proses-proses di Odoo yang lambat ketika ukuran database sudah diatas 100GB.

Enroll Back

What you will learn?

Introduction

  • Anda pernah punya masalah ini?

  • Successful Case Studies

  • Solusi Inti

Hardware Specification

  • Hardware Sizing

  • Worker number calculation

  • Memory size calculation

  • Contoh kasus perhitungan core worker dan RAM

  • Calculation chart

  • Standard Transaction Sizing

  • Standard SQL Numbers

  • Upsizing

Odoo Deployment

  • Odoo Architecture

  • Odoo Deployment Strategy

  • Load Balancer and Monitoring

  • Odoo Configuration Keys

  • Contoh Praktek Konfigurasi Odoo

  • Odoo Configuration Template

  • Nginx Load Balancer Configuration

  • Contoh Praktek Konfigurasi Nginx

  • Contoh Troubleshooting Odoo dan PostgreSQL

  • Contoh Praktek Konfigurasi SSL

  • Odoo Network Example

PostgreSQL Deployment

  • PostgreSQL Deployment Strategy

  • PostgreSQL Tuning Tools

  • PostgreSQL Configuration

  • PostgreSQL Configuration Example

  • Praktek Konfigurasi PostgreSQL

  • Praktek Cek Konfigurasi PostgreSQL

Linux Kernel Tuning

  • Huge Pages

  • vm.swappiness

  • vm.overcommit_memory and vm.overcommit_ratio

  • vm.dirty_background_ratio and vm.dirty_background_bytes

  • vm.dirty_ratio and dirty_bytes

Monitoring

  • Apa yang perlu di Monitoring

  • Instalasi Munin

  • Munin Master

  • Munin Node

  • PostgreSQL monitoring Plugin

  • Odoo monitoring Plugin

  • Nginx Monitoring Plugin

  • Fail2ban Monitoring Plugin

  • Munin Live Example

Analize

  • Beberapa faktor penentu performance Odoo

  • SQL Log and Pg badger

  • Tabel Statistic yang Penting

  • Analisa Locking dan PG Activity

  • Cara Mengecilkan Ukuran Tabel

  • Problem aplikasi Odoo

SQL Performance Tuning

  • Optimasi SQL Code !

  • Cara capture SQL statement via Odoo debug

  • Cara capture SQL statement via PostgreSQL log

  • Contoh kasus POS Validate Closing

  • Contoh kasus lainnya

Enroll Back