Results for “high performance”

Graphile Worker expert for high-performance PostgreSQL job queues with trigger-based job creation and millisecond job pickup via LISTEN/NOTIFY. Use when "graphile worker, postgres trigger job, listen notify queue, postgraphile worker, database trigger queue, transactional job, graphile-worker, postgresql, triggers, listen-notify, job-queue, postgraphile, high-performance, supabase" mentioned.

The English summary is being prepared. Showing the original description.

Reviews Elixir code for performance issues including GenServer bottlenecks, memory usage, and concurrency patterns. Use when reviewing high-throughput code or investigating performance issues.

The English summary is being prepared. Showing the original description.

Biome is a high-performance Rust-based toolchain for JavaScript, TypeScript, JSX, JSON, CSS, and GraphQL that unifies formatting and linting in a single tool. With 97% Prettier compatibility and over 450 lint rules, Biome replaces ESLint and Prettier with dramatically faster execution.

The English summary is being prepared. Showing the original description.

Guide for diagnosing and improving MSBuild project evaluation performance. Only activate in MSBuild/.NET build context. USE FOR: builds slow before any compilation starts, high evaluation time in binlog analysis, expensive glob patterns walking large directories (node_modules, .git, bin/obj), deep import chains (>20 levels), preprocessed output >10K lines indicating heavy evaluation, property functions with file I/O ($([System.IO.File]::ReadAllText(...))), multiple evaluations per project. Covers the 5 MSBuild evaluation phases, glob optimization via DefaultItemExcludes, import chain analysis with /pp preprocessing. DO NOT USE FOR: compilation-time slowness (use build-perf-diagnostics), incremental build issues (use incremental-build), non-MSBuild build systems. INVOKES: binlog MCP server tools (evaluations, evaluation_global_properties, evaluation_properties, imports, properties); falls back to dotnet msbuild -pp:full.xml for preprocessing, /clp:PerformanceSummary.

The English summary is being prepared. Showing the original description.

Audit and improve SwiftUI runtime performance. Use when diagnosing slow rendering, janky scrolling, high CPU, memory usage, excessive view updates, layout thrash, body evaluation cost, identity churn, view lifetime issues, lazy loading, Instruments profiling guidance, and performance audit requests.

The English summary is being prepared. Showing the original description.

Facebook's library for efficient similarity search and clustering of dense vectors. Supports billions of vectors, GPU acceleration, and various index types (Flat, IVF, HNSW). Use for fast k-NN search, large-scale vector retrieval, or when you need pure similarity search without metadata. Best for high-performance applications.

The English summary is being prepared. Showing the original description.

Facebook's library for efficient similarity search and clustering of dense vectors. Supports billions of vectors, GPU acceleration, and various index types (Flat, IVF, HNSW). Use for fast k-NN search, large-scale vector retrieval, or when you need pure similarity search without metadata. Best for high-performance applications.

The English summary is being prepared. Showing the original description.

Helps design ClickHouse tables, write analytical queries, and improve slow queries. Covers loading data in batches, preparing reusable summaries, and monitoring performance for large datasets, real-time dashboards, and time-series analysis.

• Designing tables for large-scale analytics
• Improving slow aggregation queries
• Loading large datasets in batches

Review interface animation code for timing, natural movement, responsiveness, rendering performance, and accessibility. Receive a table of specific problems, suggested changes, and reasons, followed by a clear decision on whether the motion meets the review standards.

• Reviewing dropdown and tooltip transitions
• Checking responsiveness during repeated interactions
• Finding animation patterns that may hurt rendering performance

Build a three slide quarterly review or roadmap presentation with a retro blue, orange, and cream palette. The self-contained HTML includes a cover, three priorities, a timeline, key performance indicators, keyboard navigation, and animated transitions.

• Presenting a quarterly review
• Sharing three priorities with a team
• Showing a roadmap alongside key performance indicators

Create website interfaces with defined typography, spacing, layered cards, and animation rules. The skill guides React, Tailwind, and HTML output, combining asymmetric layouts with mobile adaptations and performance constraints for a consistent visual direction.

• Designing an asymmetric website layout
• Refining cards, buttons, and navigation
• Adding motion with mobile performance in mind

Check whether images visible when a page first opens are unnecessarily lazy loaded, meaning their loading is deferred. Verify rendering delays with performance measurements, then guide changes to loading attributes and request priority.

• Review loading settings for hero images
• Investigate image loading delays affecting LCP
• Adjust loading attributes for images in the initial viewport

Build web animations with Anime.js, from staggered text and image reveals to SVG shape changes and animated lines. Coordinate timing, overlapping motion, and responses to user input while accounting for accessibility and performance.

• Coordinate multi-stage landing page animations
• Reveal text and grids with staggered timing
• Animate SVG shapes and line drawing

Helps design ClickHouse tables, write analytical queries, and build data ingestion workflows. Covers batch inserts, precomputed summaries, and performance monitoring for teams working with large datasets and time-based activity analysis.

• Designing tables for large analytical datasets
• Improving slow aggregation queries
• Analyzing user retention and conversion steps

Investigate database slowdowns and plan measurable improvements to queries, indexes, caching, and scaling. The skill covers SQL and NoSQL systems, with guidance on monitoring, load testing, migrations, and balancing performance against cost.

• Analyze slow SQL queries and execution plans
• Resolve repeated database calls in APIs
• Plan indexes and caching for high traffic

Build searches with Qdrant that find similar content and filter results by attributes. The skill covers document retrieval for AI answers, vector storage, memory optimization, and distributed deployment for larger collections.

• Building document retrieval for AI answers
• Combining similarity search with category or date filters
• Reducing memory use for large vector collections

Guides migration of existing codebases to Rust without unsafe code, covering architecture, implementation, testing, and output comparisons. It measures performance before and after optimization and produces an interactive HTML report documenting results and unresolved differences.

• Migrating a GitHub or local codebase to Rust
• Comparing original and migrated program outputs
• Measuring and optimizing a Rust port

Review UI animation code for purposeful motion, responsive timing, correct origins, performance, and accessibility. Get a table of specific changes with reasons, followed by an approval or blocking decision ranked by impact.

• Review dropdown and tooltip animations
• Identify unnecessary motion in frequent actions
• Check animation performance risks

Build searches with Qdrant that find similar content and filter results by attributes. The skill covers document retrieval for AI answers, vector storage, memory optimization, and distributed deployment for larger collections.

• Building document retrieval for AI answers
• Combining similarity search with category or date filters
• Reducing memory use for large vector collections

Write and review YARA-X rules, which identify malware through file patterns. Refine detection strings and conditions, check rule quality with included scripts, test against clean files, improve performance, and migrate rules from legacy YARA.

• Write rules targeting a specific malware family
• Review false positives and slow detection rules
• Migrate existing YARA rules to YARA-X

Use border-beam to add moving edge highlights or breathing glows to React controls and panels. Connect effects to loading, selection, and focus states while retaining clear text, static indicators, keyboard focus, and support for reduced motion.

• Adding a breathing glow to a processing panel
• Highlighting a selected card or current step
• Adding a moving bottom edge to an input

Search YouTube by keyword and upload date, then collect video metrics and channel details through BrowserAct. Results include views, likes, comments, duration, and subscriber counts for comparing videos and researching activity around a topic.

• Collecting metrics for videos published this week
• Researching recent videos from competing channels
• Comparing reactions to campaign videos

Guide for diagnosing and improving MSBuild project evaluation performance. USE FOR: builds slow before any compilation starts, high evaluation time in binlog analysis, expensive glob patterns walking large directories (node_modules, .git, bin/obj), deep import chains (>20 levels), preprocessed output >10K lines indicating heavy evaluation, property functions with file I/O ($([System.IO.File]::ReadAllText(...))), multiple evaluations per project. Covers the 5 MSBuild evaluation phases, glob optimization via DefaultItemExcludes, import chain analysis with /pp preprocessing. DO NOT USE FOR: compilation-time slowness (use build-perf-diagnostics), incremental build issues (use incremental-build), non-MSBuild build systems.

The English summary is being prepared. Showing the original description.

Breaks down campaign performance by geographic location at whatever level matters — country, state, city, DMA, zip code. Flags underperforming geos that are quietly eating budget and high-performing ones that deserve more spend. Recommends geo bid adjustments or campaign splits. Platform: Google and Meta.

The English summary is being prepared. Showing the original description.