performance-optimization

Diagnose bottlenecks and tune databases, caching, and batch processing in enterprise applications.

2|1|Updated Apr 15, 2026
One-click install
npx skills add https://github.com/erphq/skills --skill performance-optimization-erphq
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: performance-optimization
Source: https://github.com/erphq/skills/tree/main/departments/information-technology/03-org-1k-plus/performance-optimization
Command: npx skills add https://github.com/erphq/skills --skill performance-optimization-erphq

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Enterprise applications frequently suffer from slow response times due to bottlenecks in database access, caching inefficiencies, and unoptimized batch workloads. This skill provides a reproducible approach to identify and mitigate these bottlenecks, enabling sub-second interactions and scalable throughput.

Core Features & Use Cases

  • Database query optimization: indexing strategies, query plan analysis, and avoiding N+1 patterns.
  • Caching layers & batch processing: design of application, data, and query caches plus scheduling for large data jobs.
  • Monitoring & capacity planning: dashboards, alerts, and capacity forecasts to prevent outages.
  • Use Case: When a dashboard query runs slowly, apply indexing, cache critical results, and schedule batch refreshes to meet SLA.

Quick Start

Run a quick performance audit to identify the top slow query and add a targeted index to accelerate it.

Frequently Asked Questions about performance-optimization

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I fix slow database queries in enterprise applications?

Improve application response times by diagnosing database bottlenecks, tuning queries with indexing strategies, and implementing caching layers. This approach eliminates slow access paths to enable sub-second interactions and scalable throughput.

What's the best way to design caching layers for scalable throughput?

The best way to design caching layers is to build application, data, and query caches that intercept frequent requests. Structured caching reduces direct database access and maintains scalable throughput under heavy enterprise workloads.

How do I set up monitoring dashboards for capacity planning?

Set up monitoring dashboards by configuring alerts and generating capacity forecasts to prevent outages. Effective capacity planning processes track resource utilization trends to ensure large-scale IT environments remain stable.

How do I schedule batch processing for large data jobs?

Schedule batch processing by designing batch jobs to handle large data workloads outside peak traffic hours. Structured batch job design and scheduling refresh critical data efficiently, preventing workload spikes from degrading application performance.

Does database tuning work for large-scale IT environments?

Database tuning works effectively for large-scale IT environments by providing reproducible bottleneck identification and indexing strategies. This scalable tuning approach mitigates slow response times and supports heavy enterprise application workloads.

Why does my dashboard query run slowly under heavy load?

Dashboard queries run slowly under heavy load due to unoptimized database access and caching inefficiencies. Apply targeted indexing, cache critical query results, and schedule batch refreshes to meet your application SLA.