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.

2

Does OpenERP support more than 200,000 products ?

By
kiran
on 8/5/13, 9:45 AM 1,500 views

From performance prospective, can OpenERP support more than 200,000 products ?

2
Ana Cristina Ponce
On 8/13/13, 12:08 PM

Yes it does

1
Xsias
On 8/5/13, 10:13 AM

Yes he can. We have a customer who has more than 500k products His OpenERP instance runs pretty well.

EDIT

For exemple, we have put the database on a SSD. (not a 15k rpm hd)

Surely you went through some optimization work. Can you edit the answer to share some more details?

Daniel Reis
on 8/13/13, 3:18 PM
0
Flyguy
On 8/6/13, 12:25 PM

We have a customer with 700K products. It was very slow, so we had to do some customization, especially on the search funtion. But it works fine now.

Hi can you please elaborate on the customizations you have done for the search function as we are facing a similar issue.

adi
on 8/13/13, 10:59 AM

just raised the postgres cache to 4gb

Steve Smith
on 9/6/13, 9:37 PM

that was only for 200k products

Steve Smith
on 9/6/13, 9:38 PM
0
adi
On 8/13/13, 11:09 AM

Also I found this very helpful

0
Steve Smith
On 8/5/13, 10:18 AM

I have 170,000 and having search issues - not finding products when searching for them.

Wonder how the guy with 500k has got round the issues.

Good servers.

Xsias
on 8/5/13, 10:28 AM

not sure what else can add to my servers. Got the db on a fast drive, 12gb ram, 4cpu :/

Steve Smith
on 8/5/13, 11:19 AM

Have you optimized you postgres configuration file?More info: wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server (can't post links so removed http part).

Laura Jarvenpaa
on 8/6/13, 7:59 AM

Will be my next port of call. Many thanks.

Steve Smith
on 8/6/13, 10:38 AM

We have put the database on a SSD. It's amazingly fast.

Xsias
on 8/12/13, 5:35 AM

Changing the settings in Postgres helped massively :)

Steve Smith
on 9/5/13, 11:05 AM

Can you share what you changed?

Bista Solutions US, Ray Carnes
on 9/6/13, 8:52 PM
0

Gustavo

--Gustavo--
950
| 2 1 4
Buenos Aires, Argentina
--Gustavo--

Python developer, big fan of sailing

Gustavo
On 8/6/13, 6:46 PM

Change the view_list.js code and remove the options available to end user. Limit the number of rows a user is able to see each time he/she opens s a view. That will help you reduce the workload on the server

0
Sohail
On 8/12/13, 5:22 AM

The True fact is that the system loads slowly when started for the first time due to very high number of products. Also if your number of products is so high then you should be depending on the system configuration of your PC (amount of RAM and CPU..) Also the sales order and other data affect the system performance if you are using version 6.1 or less of OpenERP. Do not clear cache of browser if pages are cached it will help with loading the application faster for frequently visited pages only.

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

0 follower(s)

Stats

Asked: 8/5/13, 9:45 AM
Seen: 1500 times
Last updated: 3/16/15, 8:10 AM