Is it possible to have 1 million products in ERPNext catalogue

ERPNext
1

Is it possible to have 1 million products in ERPNext catalogue ?

2

Hi @Sagesrepo,

Managing 1 million products in ERPNext can be challenging and depends on factors like database optimization, server resources, network speed, version, and customization. The system’s ability to handle such a large catalog relies on proper indexing, partitioning, and resource allocation. It’s essential to use an adequately configured server with sufficient CPU, RAM, and storage. The version should be up-to-date to benefit from any optimizations. Customizations, including scripts and fields, must be optimized for scalability.

I hope this helps.

Thank You!

3

Actually we have some 1 million item already and facing slow down of the server.
What can be done about it?

4

Hi @Sagesrepo,

The answer of @NCP already explain what to do, but not how to do it.
If actually you do not have the skills of linux system administrator and the skilld of a database manager, you should read the documentation about Frappe technical architecture and understand all the system software layer use when you call a page or an API call

You can first check gunicorn workers
https://frappeframework.com/docs/user/en/basics/site_config

And check how too log long request in marriadb

Try these query with EXPLAIN

and decide if you need to CREATE INDEX on some columns after that

Check clustered solution

Monitor process CPU consumption / swap of your server
https://perf.wiki.kernel.org/index.php/Main_Page

Friendly version : https://www.baeldung.com/linux/log-memory-consumption

After that you can decide if you need to add more RAM or CPU. The fact is with linux more RAM you have more RAM it will take, it’s not always the solution to add hardware, a smart investigation will give the key to decide what to do.

Do not forget that your needs will change according your usage, today you have 1 million products, tomorrow you will have 2 million sales invoices (I wish it for you).

According your other posts on this forum, you have 2 choices

  • Upgrade your skills
  • Find someone that have the skills

Hope you’ll find your way to optimize your hosting system

1 Like
5

Thank You…