This question has been flagged

Hello Experts,


For e.g., I’m having database with huge amount of data,
Every years it increases data with 400k records,
Having big issue is on concurrent update, database integrated with many eCommerce database,  and synchronized with my database, which is causing issue on concurrent update,

How could reduce the concurrent update issue, by upgrading servers(Hardware) or any additional configuration.

Any Guidance or suggestion appreciated

Thanks & Regards,

Anil.


Avatar
Discard

Even am facing this issue, One of the biggest drawback of Odoo.

Best Answer

if every years data is increases 400K is not issues because postgres limit is bigger then you think. just provide good hardware like 64GB RAM and i5 or i7 processer. recently i upgraded one server. it  is working to faster then older every year my database is increase as 1.2 GB. we are working since last 6 years. so, please choose hardware as high quality RAM. enough to run your server. thanks

Avatar
Discard
Author

Thanks for reply, concerned is not about the speed, we could upgrade the hardware, but does it resolve the concurrency update issue?