Ir al contenido
Esta pregunta ha sido marcada
xmlrpcecommerceodoo12
1 Responder
6133 Vistas
Avatar
Samo Arko

I'm trying to optimize my odoo server. I don't know in PGTune what DB type to select. The server is for hosting eCommerce websites, but it syncs data from a pos terminal. So all customers and products get created/updated in odoo trough xmlrpc calls. 

The initial sync runs from a few seconds (below 1000) to a few hours (above 20000) depending on the number of products.

The sync just eats all the resources of the server so the websites are slow in responding. I think it's because of my postgresql configuration.

I have configured workers and cpu_limits. Postgres is configured for type Web application but I don't think this is the best configuration.

What DB Type should I select in PGTune for my needs?

Can I limit the resources that are used for xmlrpc calls?

Avatar
Descartar
Avatar
Caitlyn Beasley
Mejor respuesta

For most Odoo setups, the “Web application” profile in PGTune is a solid start. You can then tweak work_mem, shared_buffers, and autovacuum settings based on load. 

If your XML-RPC sync is heavy, consider a separate worker or queue so it doesn't block web requests. Monitor for long queries and I/O limits — often the real gain comes from faster disks or splitting DB and app servers.

Avatar
Descartar
Publicaciones relacionadas Respuestas Vistas Actividad
How to disable "Add to Cart" button in E-commerce product page in Odoo 12? Resuelto
ecommerce odoo12
Avatar
Avatar
Avatar
Avatar
Avatar
5
oct 23
18392
when adding product to cart while accessing site with www I get catr is empty!
ecommerce odoo12
Avatar
0
jun 20
3852
How to add a new Payment Acquirers in Odoo12 eCommerce Resuelto
ecommerce odoo12
Avatar
Avatar
5
may 20
6216
AttributeError: 'NoneType' object has no attribute '_get_first_possible_combination'
ecommerce cart odoo12
Avatar
0
oct 22
659
My Cart menu doesn't show up
ecommerce cart odoo12
Avatar
0
oct 22
379