performance-guide

Optimize web application performance across PHP, JavaScript, and database layers.

8|Updated Feb 9, 2026

Search Tags:#performance #caching #database #php #optimization #javascript #vue

Ready to run

npx skills add https://github.com/zb-ss/opencode-workflows --skill performance-guide-zb-ss

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: performance-guide
Source: https://github.com/zb-ss/opencode-workflows/tree/main/skill/performance-guide
Command: npx skills add https://github.com/zb-ss/opencode-workflows --skill performance-guide-zb-ss

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill addresses performance bottlenecks in web applications by providing strategies and best practices for optimizing PHP, JavaScript, database queries, and caching mechanisms.

Core Features & Use Cases

Database Optimization: Techniques to prevent N+1 queries, effective indexing, and query analysis.
Language-Specific Tuning: Performance tips for PHP (loops, data structures, generators) and JavaScript/Vue (virtual DOM, lazy loading, debouncing).
Caching Strategies: Implementing multi-layered caching and utilizing HTTP caching headers.
Profiling Tools: Recommendations for tools to diagnose performance issues.
Use Case: A developer facing slow page load times can use this Skill to identify and fix inefficient database queries and optimize frontend JavaScript execution.

Quick Start

Review the database indexing strategies for optimizing query performance.

Frequently Asked Questions about performance-guide

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

FAQPage Schema

How do I fix the N+1 query problem in my PHP web application?▼

To fix the N+1 query problem, you must implement database optimization strategies like eager loading and proper query analysis. This Skill provides guidance on resolving these inefficient database queries to significantly reduce page load times and improve application responsiveness.

What's the best way to optimize JavaScript virtual DOM efficiency in Vue?▼

Optimizing JavaScript virtual DOM efficiency in Vue involves using techniques like lazy loading and debouncing. This Skill offers language-specific tuning guidance to streamline frontend execution and reduce client-side performance bottlenecks effectively.

How do I implement multi-layered caching and HTTP caching headers?▼

Implementing multi-layered caching requires configuring various cache stores alongside proper HTTP caching headers. This Skill outlines caching strategies to help web applications minimize redundant data fetching and decrease server response times efficiently.

Which profiling tools should I use to diagnose slow PHP and database performance?▼

To diagnose slow PHP and database performance, you should use dedicated profiling tools to identify execution bottlenecks. This Skill provides recommendations for profiling tools to accurately pinpoint inefficient queries and slow code loops.

Can I optimize PHP loops and data structures for better web performance?▼

Yes, you can optimize PHP loops and data structures by leveraging generators and efficient iteration techniques. This Skill delivers language-specific tuning tips to refine PHP data processing and enhance overall web application speed.

When should I apply database indexing strategies to improve query performance?▼

You should apply database indexing strategies when query analysis reveals slow data retrieval operations. This Skill helps you identify when to implement effective indexing to prevent performance bottlenecks and accelerate database queries.