Multiple odoo server sharing same database ?
Let's imagine following situtation :
- 1 odoo database
- multi-company, which will lead to a large number of users
We want to avoid slowing down all users when making expensive odoo operation (e.g. reporting, etc..)
I am wondering if it would be possible / a good idea to make several odoo instance on separated server/container, all using the same DB (in the same DB server) ?
Or is that non-sense / innefficient ? In that case what would be a better idea?
Thanks for your feedback!
Edit : I am already using odoo workers, but with many workers, woundn't it reach server capacity limit at some point? That's why i thought of multiple servers. But maybe upgrading the server and increasing the number of workers would be enough.