We have had lots of issues with our Community Odoo instance being unresponsive and slow, and sometimes timing out on users.

We initially followed the Odoo documentation on calculating the number of workers to run and memory.

https://www.odoo.com/documentation/12.0/setup/deploy.html

We have gradually upped certain values for different reasons.:

We removed the limit on our Cron timeout and have two cron workers to relieve background events not completing.

We also have bumped up CPU time limit by 10 times, although this may not be appropriate.


We are hoping to get more advice on how to configure odoo for best performance. Whats provided by the Odoo team is not sufficient.

Dump of our config:

[options]
addons_path = redacted
admin_passwd = redacted
csv_internal_sep = ,
data_dir = /opt/odoo/odoo12/.local/share/Odoo
db_host = False
db_maxconn = 64
db_name = False
db_password = False
db_port = 5432
db_sslmode = prefer
db_template = template0
db_user = redacted
dbfilter =
demo = {}
email_from = redacted
geoip_database = /usr/share/GeoIP/GeoLite2-City.mmdb
http_enable = True
http_interface = 127.0.0.1
http_port = 12069
import_partial =
limit_memory_hard = 10690208256
limit_memory_soft = 9408506880
limit_request = 8192
limit_time_cpu = 1100
limit_time_real = 1200
#limit_time_cpu = 110
#limit_time_real = 120
limit_time_real_cron = -1
list_db = True
log_db = False
log_db_level = warning
log_handler = :INFO
log_level = info
logfile = redacted
logrotate = True
longpolling_port = 12072
max_cron_threads = 2
netrpc_interface = 127.0.0.1
osv_memory_age_limit = 1.0
osv_memory_count_limit = False
pg_path = None
pidfile = None
proxy_mode = True
reportgz = False
server_wide_modules = base,web
smtp_password = False
smtp_port = 25
smtp_server = localhost
smtp_ssl = False
smtp_user = False
syslog = False
test_enable = False
test_file = False
test_tags = None
translate_modules = ['all']
unaccent = False
without_demo = False
workers = 9
xmlrpcs_port = 12073