ERPNext Performance Optimization Case Study: SMOOR Chocolates

From 15 Minutes to Under 30 Seconds: Transforming ERPNext Performance at SMOOR Chocolates

ERPNext Performance Optimization Case Study - SMOOR Chocolates

FinByz Tech, a Certified ERPNext Partner specializing in Performance Engineering, partnered with SMOOR Chocolates to address critical performance bottlenecks within their ERPNext v13 instance. This case study details how a focused, one-month optimization effort delivered a 30x improvement in transaction speed, deep SQL-level optimization, and production-grade infrastructure tuning, ensuring SMOOR's operational backbone could support their rapid growth.

The Client

SMOOR Chocolates, Bengaluru

Founded in 2015, SMOOR Chocolates has rapidly ascended to become India's premier premium couverture chocolate brand, serving clients ranging from individual consumers to large corporations including a significant Rs 2.5 Cr order from Titan.

The Engagement

Duration: 1 Month

Focus: Performance Optimization for a scaling chocolatier's ERPNext v13 instance following their acquisition by Rebel Foods in 2022.

Why Not Upgrade?

SMOOR's ERPNext v13 was heavily customized by their previous partner. A direct upgrade to v14 or v15 risked breaking essential workflows. The strategic decision: optimize the existing instance to peak performance first.

The Problem

  • <strong>Crippling Transaction Latency:</strong> Saving a single Purchase Order with 30-35 line items took approximately 15 minutes. Similar delays plagued Sales Orders, Purchase Receipts, and Sales Invoices.

  • <strong>Productivity Loss:</strong> Procurement, dispatch, and accounts teams lost valuable productive hours daily due to system slowdowns.

  • <strong>Operational Risk:</strong> A critical disk-full incident on the AWS instance threatened a complete operational shutdown.

  • <strong>Database Inefficiency:</strong> Unoptimized SQL queries consumed excessive CPU resources, leaving insufficient headroom for concurrent users.

  • <strong>Code Vulnerabilities:</strong> Custom code with nested loop patterns caused thousands of inefficient database calls per transaction.

Measured Impact

FinByz Tech implemented a rigorous performance optimization process, resulting in dramatic improvements across key transaction types:

TransactionBeforeAfterImprovement
Purchase Order (30-35 items)~15 min< 25 sec36x faster
Sales Order~8 min< 20 sec24x faster
Purchase Receipt / GRN~10 min< 20 sec30x faster
Sales Invoice~6 min< 15 sec24x faster
Purchase Invoice~7 min< 15 sec28x faster
Stock Entry~5 min< 10 sec30x faster

Our Optimization Approach

Over a concentrated one-month period, FinByz Tech employed a systematic, six-step performance engineering methodology addressing every layer of the technology stack:

CPU & Query Profiling

In-depth analysis of CPU utilization attributed to individual SQL queries. A comprehensive report detailing high-CPU queries was provided to SMOOR's IT team.

SQL Indexing & Partitioning

Optimized slow-performing queries through the strategic implementation of SQL indexing and table partitioning for the large, complex database.

Custom Code Optimization

Identified and refactored custom code exhibiting inefficient loop-within-loop patterns, achieving the same business logic with vastly improved execution times.

Query Caching

Implemented caching mechanisms for frequently executed queries called multiple times within short intervals, eliminating redundant database calls during single transactions.

SQL Configuration Tuning

Fine-tuned MariaDB/MySQL configurations to maximize utilization of available RAM, optimizing buffer pools, query cache settings, and connection limits.

Gunicorn Worker Optimization

Rebalanced Gunicorn worker processes to efficiently leverage all available CPU cores, significantly enhancing handling of concurrent requests and overall system throughput.

Results at a Glance

The numbers speak for themselves

Transaction Speed

30x

Average Improvement

Average transaction speed improvement across all document types, restoring productive hours for every team.

All Transactions Under

30s

Max Save Time

Every critical business transaction now completes in under 30 seconds, from purchase orders to sales invoices.

Zero Downtime

0

Operational Downtime

Rapid crisis response ensured zero operational downtime during the critical disk-full emergency incident.

Delivered In

1 Month

Project Timeline

Complete end-to-end performance engineering engagement delivered within a single month.

Crisis Response: Disk-Full Emergency

When SMOOR's AWS server disk became full, halting all operations, FinByz Tech responded immediately. Without adhering to standard ticket SLAs, our team proactively cleared unnecessary activity logs and non-critical data, restoring system functionality. This rapid intervention ensured zero operational downtime while SMOOR arranged for an AWS database storage upgrade.

This swift and decisive action exemplifies the level of commitment FinByz Tech brings to every client engagement.

Conclusion

For a premium brand like SMOOR Chocolates, where timely dispatches and efficient order processing are paramount, system downtime translates directly to lost business. FinByz Tech's performance engineering initiative did more than just fix a slow ERP system; it restored valuable operational hours for SMOOR's teams and established a robust performance baseline capable of scaling with their continued business growth.

Team FinByz Tech

ERPNext Performance Engineering Custom Development 24x7 Support

FINBYZ TECH PVT LTD

Certified ERPNext Partner 10+ Years 200+ Projects 15+ Countries

www.finbyz.tech

ERPNext Frappe AI Automation Custom Dev

Talk to our Experts

Ready to Scale with Smart Tech? Let's Talk.

Transform your business processes with AI-powered automation and expert implementation.

Trusted by 100+ businesses
Talk to our Experts

Ready to Scale with Smart Tech? Let's Talk.

Transform your business processes with AI-powered automation and expert implementation.

Trusted by 100+ businesses

Frequently Asked Questions

Find answers to common questions about our services

Still have questions?

Contact Support

Related Read

ERPNext Performance Optimization for Speed & Efficiency

ERPNext Performance Optimization for Speed & Efficiency

ERPNext Performance Optimization for Speed & Efficiency

View More
ERPNext Support Services | AMC, Bug Fixes, Customization & Functional Support

ERPNext Support Services | AMC, Bug Fixes, Customization & Functional Support

ERPNext Support Services | AMC, Bug Fixes & Customization

View More
ERPNext System Maintenance Updates Performance Optimization

ERPNext System Maintenance Updates Performance Optimization

ERPNext System Maintenance & AMC Services | FinByz Tech

View More

Book a Free Consultation

Get started with your free demo today and discover how our solutions can transform your business

Quick Response
Free Consultation

Get Started Today

Fill out the form below and we'll get back to you within 24 hours

By submitting this form, you agree to our privacy policy and terms of service.

ERPNext Optimization: SMOOR Chocolates Case Study | FinByz Tech