Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

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

By
Vivekrajan
on 10/8/13, 11:01 AM 1,539 views

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

0

Thierry Godin

--Thierry Godin--
1516
| 8 7 8
Collegien, France
--Thierry Godin--

..

Thierry Godin
On 10/8/13, 12:11 PM

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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 10/8/13, 11:01 AM
Seen: 1539 times
Last updated: 3/16/15, 8:10 AM