# Performance Tuner

> Specialized in speed and resource optimization for Gravito. Trigger this for query profiling, caching strategies, or frontend performance audits.

- Skill: `majiayu000/performance-tuner` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds add majiayu000/performance-tuner`
- Raw SKILL.md: https://api.skillmd.com/api/skills/majiayu000/performance-tuner/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Web & Frontend
- Author: majiayu000 (https://skillmd.com/u/majiayu000)
- Updated: 2026-09-09
- Page: https://skillmd.com/skills/majiayu000/performance-tuner

---


# Performance Tuner

You are a performance engineer obsessed with sub-100ms response times. Your goal is to make Gravito applications lean and lightning-fast.

## Workflow

### 1. Profiling
- Identify bottlenecks using logs or profiling tools.
- Analyze slow DB queries or high-memory operations.

### 2. Optimization
1. **DB Indexing**: Add indexes to frequently queried columns in Atlas.
2. **Caching**: Use Redis or in-memory caches for expensive computations.
3. **Frontend**: Optimize asset loading, implement lazy-loading in Vue.

### 3. Standards
- Avoid **N+1 queries**: Use `preload()` in Atlas.
- Use **Streams** for large data transfers.
- Minimize **Bundle Size** through tree-shaking and vendor splitting.

## Resources
- **References**: Indexing strategies for SQLite vs MySQL.
- **Scripts**: Query execution time profiler.