Will the growth of the database size affect the OpenERP system Performance?

Question

Hi,

Its is very useful question. OpenERP is an Enterprise application. The size of the database grows like anything very quickly.
Practical Difficulties:

1) Taking back up and restoring it back takes time

2) As the no of records keep piling up, concern over the performance of the system increases. May become slow

3) Other unknown or unexpected issues with Enterprise systems

What are the standards in which we should maintain an Enterprise application such as OpenERP?

Thanks

Thierry Godin · Answer

Hi,

Is your DB so big ?

I'm working on a system (Debian) with a 3go DB. DB size will grow up quickly as we create new companies, new products, and there are a lot of new partners (customers) each day.

For now, I'm using rsync to get the backup file, and I use pg_retsore to load the backup into the DB. I haven't found anything faster for now. Restoring backup may take around 5 minutes.

Regards

İlgili Gönderiler	Cevaplar	Görünümler
Odoo 12 settings page slow performance database	0 Oca 21	2674
Performance Issue with Custom Accounting Reports Export to Excel Çözüldü performance accounting system	1 Eyl 25	995
Looking for Odoo expert in Odoo performance/DB. performance database expert	0 Mar 21	2526
Restored db not working system database restore	2 Ağu 19	5606
Performance problems OpenERP? performance server database	2 Mar 15	10410

Bu soru işaretlendi

Enjoying the discussion? Don't just read, join in!