Odoo Help


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.


Does OpenERP support more than 200,000 products ?

on 8/5/13, 9:45 AM 1,479 views

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

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

Yes it does

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.


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
On 8/13/13, 11:09 AM

Also I found this very helpful



| 2 1 4
Buenos Aires, Argentina

Python developer, big fan of sailing

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

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.

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
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.

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.

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.

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

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)


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