skills.rest
withmartian-sandbox
withmartian-sandboxOFFICIAL
Explore all skills by this author →
GitHub

performance-optimization

Identify and alleviate performance bottlenecks in HMIS data access and operations.

Updated Aug 27, 2026
Search Tags:#performance#caching#database#optimization#query-tuning#dto#hmis
One-click install
npx skills add https://github.com/withmartian-sandbox/ghrc-x-a78d77e2f0a84f43b4d486d418566b5b --skill performance-optimization-withmartian-sandbox
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: performance-optimization
Source: https://github.com/withmartian-sandbox/ghrc-x-a78d77e2f0a84f43b4d486d418566b5b/tree/main/.claude/skills/performance-optimization
Command: npx skills add https://github.com/withmartian-sandbox/ghrc-x-a78d77e2f0a84f43b4d486d418566b5b --skill performance-optimization-withmartian-sandbox

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Performance optimization patterns for the HMIS project. Use when optimizing slow queries, improving autocomplete performance, tuning database queries, reducing page load times, optimizing report generation, or investigating performance issues.

Core Features & Use Cases

  • DTO-based data flows to minimize entity conversions.
  • Caching autocomplete results to speed up controllers and preserve data for converters.
  • Deferred or background execution of expensive tasks to improve responsiveness.
  • Query and database tuning using indexed columns and pagination to reduce load.

Quick Start

Analyze current HMIS performance bottlenecks and apply the recommended optimization patterns to improve response times.

Frequently Asked Questions about performance-optimization

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

FAQPage Schema
How do I optimize slow database queries in HMIS modules?▼

Optimize slow HMIS database queries by applying indexed column tuning and pagination to reduce load. This pattern targets data access bottlenecks across EMR, inventory, and billing workflows to improve response times.

What's the best way to improve autocomplete performance using caching?▼

Improve autocomplete performance by caching query results to speed up controllers and preserve data for converters. This reduces repetitive database hits during user-facing operations in HMIS modules.

How do DTOs minimize entity conversions for data flow optimization?▼

DTOs minimize entity conversions by streamlining data transfer objects directly into data flows. This pattern reduces unnecessary processing overhead during HMIS user-facing operations and report generation.

Can I use deferred workloads for HMIS report generation?▼

You can use deferred or background execution of expensive tasks for HMIS report generation. This approach improves system responsiveness by offloading heavy processing from immediate user requests.

When should I apply server-side optimizations for page load issues?▼

Apply server-side optimizations for page load issues when experiencing bottlenecks in HMIS data access. Combining indexed queries, pagination, and caching targets performance constraints across EMR and billing workflows.

Related Skills

Explore More Software Engineering Skills→
514-labs514-labs
3

514-perf-optimize

Profiles a Moose deployment to identify slow queries and bottlenecks across seven stages.

Official
Advanced
Extremez-SuryaExtremez-Surya

next-cache-components

Configure Next.js 16 caching directives and migrate from unstable_cache to use cache.

Community
Advanced
Mentor-WizardMentor-Wizard
10

postgresql-optimization

Analyze PostgreSQL queries with EXPLAIN ANALYZE and tune indexes and configuration.

Official
Advanced
janekmjanekm

convex-development

Enforce type-safe Convex queries, mutations, and access control patterns.

Community
Advanced