frappe-performance-optimizer

What problem does it solve?

Slow queries, inefficient data access patterns, and a lack of proper caching can significantly degrade the performance of Frappe applications. This Skill generates optimized code to address these common bottlenecks.

Core Features & Use Cases

• Query Optimization: Generate efficient SQL queries with appropriate indexing suggestions to drastically speed up data retrieval.
• Caching Implementation: Implement robust caching strategies for expensive calculations or frequently accessed data using Frappe's built-in cache.
• Batch Operations: Provide patterns for bulk updates and inserts to improve the efficiency of large-scale data modifications.
• Use Case: Optimize a slow report query by suggesting appropriate database indexes and implementing a cache for the report's results, reducing load times from minutes to seconds.

Quick Start

Optimize the get_item_price function by adding caching for 1 hour to reduce database load.