Writing & Content
PromptBeginner5 minmarkdown
- Query optimization: rewrite queries using execution plan analysis
eliminate unnecessary subqueries and joins
0
Explore
Find agent skills by outcome
14,065 skills indexed with the new KISS metadata standard.
Showing 24 of 14,065Categories: Data & Insights, Coding & Debugging, Data, Productivity, Writing & Content
Coding & Debugging
PromptBeginner5 minmarkdown
- **Techniques**: Dynamic programming
memoization
0
Data
PromptBeginner5 minmarkdown
- **Data Structures**: Map vs Object for lookups
Set vs Array for uniqueness
0
Coding & Debugging
PromptBeginner5 minmarkdown
- Define performance budgets for critical paths (API response times
page load metrics
0
Data
PromptBeginner5 minmarkdown
- Apply specific optimizations based on profiling data: select optimal data structures
implement caching
0
Data
PromptBeginner5 minmarkdown
- Analyze database query patterns for N+1 problems
unnecessary joins
0
Data
PromptBeginner5 minmarkdown
- Record reproducible benchmark conditions (hardware
data volume
0
Data
PromptBeginner5 minmarkdown
- Collect database query execution plans to identify slow operations
missing indexes
0
Coding & Debugging
PromptBeginner5 minmarkdown
Follow this systematic approach to deliver measurable
data-driven performance improvements while maintaining code quality and reliability.
0
Coding & Debugging
PromptBeginner5 minmarkdown
- **Accelerate frontend rendering** via code splitting
tree shaking
0
Productivity
PromptBeginner5 minmarkdown
- Assign each task a stable ID (e.g.
TASK-1.1) and use checklist items in outputs.
0
Data
PromptBeginner5 minmarkdown
- **Tune database query performance** by analyzing execution plans
eliminating N+1 problems
0
Productivity
PromptBeginner5 minmarkdown
- Treat every requirement below as an explicit
trackable task.
0
Data
PromptBeginner5 minmarkdown
You are a senior performance optimization expert and specialist in systematic analysis and measurable improvement of algorithm efficiency
database queries
0
Coding & Debugging
PromptBeginner5 minmarkdown
**RULE:** When using this prompt
you must create a file named `TODO_optimization-auditor.md`. This file must contain the findings resulting from this research as checkable checkboxes that can be coded and tracked by an LLM.,TRUE,TEXT...
0
Coding & Debugging
PromptBeginner5 minmarkdown
- **Evidence**: Specific code path
pattern
0
Coding & Debugging
PromptBeginner5 minmarkdown
Write all proposed optimization findings and any code snippets to `TODO_optimization-auditor.md` only. Do not create any other files. If specific files should be created or edited
include patch-style diffs or clearly labeled file blocks inside the TODO.
0
Coding & Debugging
PromptBeginner5 minmarkdown
- **Unbounded data loading**: Queries or API calls without pagination
limits
0
Coding & Debugging
PromptBeginner5 minmarkdown
- **Dead code and unused exports**: Functions
classes
0
Data
PromptBeginner5 minmarkdown
- Identify unnecessary copies of large data structures (pandas DataFrames
dicts)
0
Coding & Debugging
PromptBeginner5 minmarkdown
- Assess removal safety for dead code (Safe
Likely Safe
0
Coding & Debugging
PromptBeginner5 minmarkdown
- Classify findings as Reuse Opportunity
Dead Code
0
Coding & Debugging
PromptBeginner5 minmarkdown
- Cite specific code paths
patterns
0
Coding & Debugging
PromptBeginner5 minmarkdown
- Dead code
unused imports
0