Week one after go-live was fast; six months later invoices take seconds to open, stock reports stall and the remote branch complains every morning. "The system is slow" becomes "the system doesn't fit us". Usually the problem is the hosting environment, not the system. Here are the ERPNext performance questions to ask before choosing or renewing hosting.

What drives ERPNext speed

  • Server resources.
  • Database size, settings and indexes.
  • Background jobs and heavy reports.
  • Unoptimised customisations.
  • Network distance and quality.
  • Version, as newer releases often improve performance.

Questions to ask

  1. What resources are really ours, dedicated or shared, and how were they sized?
  2. Can we scale easily, without migration or downtime?
  3. Where is the server? Pick the region nearest most users, within data-location rules.
  4. How are background workers managed and monitored?
  5. How are heavy reports handled: background runs, off-peak schedules, separate analytics such as Insights?
  6. Is performance monitored, including slow queries and alerts?
  7. How is the database maintained as logs and tables grow?
  8. What is the upgrade plan; see ERPNext upgrade benefits.

Signs the problem is hosting

SignLikely causeAction
Slow at set times dailyShared resources or heavy jobsMove jobs off-peak or add resources
Slow in one branchNetwork or distanceTest the link, choose a nearer region
One screen always slowUnoptimised customisation or reportReview code or query
Late notifications and emailToo few workersAdd and monitor workers
Slower month by monthUnmaintained database growthClean logs and maintain the database

Test before you sign

  1. A trial environment with the proposed resources.
  2. Your data or similar volume.
  3. Most-used screens from several branches.
  4. Your heaviest reports, timed.
  5. Several users at once.

Frappe Cloud or a private server?

Frappe Cloud is managed hosting from ERPNext's makers with resource plans, regions, monitoring and upgrades; a private server gives full control but needs a team. See cloud vs on-premise and ERPNext on Frappe Cloud. Operion sizes, hosts and monitors through hosting services; talk to us.

Frequently asked questions

Why does ERPNext slow down over time?

Usually database growth without maintenance, insufficient resources, peak-time heavy jobs or unoptimised customisations.

How many resources do I need?

It depends on concurrent users, volume and customisations; size after analysis and test.

Does server location matter?

Yes, distance adds time to every request.

Do upgrades improve performance?

Often, after testing customisations.