Skip to Content
This question has been flagged
performancesystemdatabasesizevs
1 Odpoveď
5819 Zobrazenia
Avatar
Vivekrajan Rayappan

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

Avatar
Zrušiť
Avatar
Thierry Godin
Best 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

Avatar
Zrušiť
Related Posts Replies Zobrazenia Aktivita
Odoo 12 settings page slow
performance database
Avatar
0
jan 21
2128
Looking for Odoo expert in Odoo performance/DB.
performance database expert
Avatar
0
mar 21
1947
Restored db not working
system database restore
Avatar
Avatar
2
aug 19
4612
Performance problems OpenERP?
performance server database
Avatar
Avatar
Avatar
2
mar 15
9755
Database size growing due to attachments!
database filestore size .sh
Avatar
Avatar
1
mar 24
3011