How does this skill improve query speed?

It analyzes query structures to suggest efficient joins, optimized WHERE clauses, and appropriate database indexes to minimize table scan times.

Does it support Redis caching implementation?

Yes, it provides boilerplate and implementation patterns for Frappe's native caching mechanisms to store expensive calculations and reduce database overhead.

Can it help with ERPNext performance issues?

Yes, it is fully compatible with ERPNext and provides optimization patterns based on core modules like Stock Ledger and Item Details.

How does it handle N+1 query problems?

The skill identifies iterative database calls and suggests bulk update or fetch patterns that consolidate multiple requests into single, efficient database operations.

Frappe Performance Optimizer

Name: Frappe Performance Optimizer
Author: Venkateshvenki404224

byVenkateshvenki404224

•

Database Management

Optimizes Frappe Framework applications by generating efficient database queries, implementing caching strategies, and managing database indexes.

This skill empowers developers to resolve performance bottlenecks in Frappe and ERPNext applications by automating the creation of high-performance code patterns. It provides specialized guidance for refactoring slow SQL queries, implementing Redis-based caching for expensive computations, and applying strategic database indexing to accelerate data retrieval. By identifying and eliminating common pitfalls like N+1 query issues and inefficient bulk updates, this skill ensures that Frappe-based systems remain scalable and responsive even under heavy data loads.

Key Features

01Redis-based caching implementation

02Efficient bulk database operations

03Strategic database indexing guidance

042 GitHub stars

05Query optimization and SQL refactoring

06N+1 query detection and elimination

Use Cases

01Speeding up slow-loading reports and dashboards

02Optimizing high-volume data imports and bulk record updates

03Reducing server load through intelligent data caching

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add venkateshvenki404224/frappe-apps-manager frappe-performance-optimizer

For use in Claude.ai and ChatGPT

Download Skill