We have encounter a performance issue with ERPNEXT while submitting a large Purchase Receipt. Approximately, it takes more than ten minutes to submit a purchase receipt that contains 4K serials. Simultaneously, no one can access the system while submitting.
Furthermore, the same problem occurs in all the doc-types where serial is there like (Sales Invoice, Purchase Receipt, Stock Entry, etc…). Additionally, we encounter the same problem with some data-intensive doctypes and reports such as the Landed Cost Voucher doctype and Gross Profit report.
Our server specifications (DigitalOcean):
VCPUS: 4 vCPUs
SSD DISK: 160 GB
TRANSFER: 5 TB
At the beginning, we didn’t encounter such a delay and performance issues. Its increasing proportionally with the data size.
I don’t know if the problem from our server or the system design?
We were happy to using ERPNEXT, but now we are afraid of this dilemma and such behaviour.