frappe-performance-optimizer

Query optimization in Frappe involves identifying inefficient SQL patterns, adding appropriate database indexes, and restructuring data access to eliminate N+1 queries. This Skill generates optimized queries with indexing suggestions that dramatically reduce execution time and database load.

Frappe's built-in cache system lets you store expensive calculation results or frequently accessed data with configurable expiration. This Skill implements robust caching strategies that serve repeated requests from memory, cutting database calls and improving response times significantly.

Batch operations and bulk inserts bypass row-by-row processing, dramatically improving performance for large datasets. This Skill provides patterns for bulk updates and inserts that satisfy scalability requirements for high-volume data modifications in Frappe deployments.

Indexes create fast lookup paths on frequently queried columns, enabling the database to retrieve matching rows without scanning entire tables. This Skill recommends and implements appropriate indexing strategies tailored to your Frappe application's query patterns.

Caching reduces redundant database queries, computation overhead, and network round trips by storing results locally. This Skill alleviates slow report generation, dashboard loading, and API responses by caching expensive operations with configurable TTL strategies.