In ERPNext, when the database and number of transactions increase to a very large level, various parts become bottlenecks. Be it hardware or software, various scaling methods need to be applied to run a large ERP system smoothly. The optimizations and scaling methods discussed in this document are for ERPNext and cover topics like database scaling, hardware scaling, code optimizations, and other relevant methods.
This business white paper explores ways to scale ERPNext as your organization grows. Using proper configuration to remove bottlenecks is vital for smooth functioning of a growing ERPNext system.
This paper covers the common challenges that users are faced with when running ERPNext on a massive scale. We explore strategies that can be employed to overcome such challenges by scaling ERPNext. ERPNext is built on a three-tier architecture with a database backend, an application layer built on a front end. Apart from this, in deployments at large volumes, data will be fed by API integrations with payment and IOT platforms while the users will be consumers of data. In this paper, we cover scaling each tier and handling specific bottlenecks that appear with the growth of an ERPNext implementation. For large volumes of accounting or stock transactions, the “ledger” will become the bottleneck and this paper will also discuss strategies for partitioning the ledger.