skills.rest
jonaseck2
jonaseck2COMMUNITY
Explore all skills by this author →
GitHub

performance-profiling

Correlate renderer and Rust host CPU profiles with SQLite bottleneck patterns.

2|Updated Apr 2, 2026
Search Tags:#query optimization#performance profiling#tauri#cpu flamegraph#sqlite tuning#renderer webview#rust diagnostics
One-click install
npx skills add https://github.com/jonaseck2/slaktforskning --skill performance-profiling-jonaseck2
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: performance-profiling
Source: https://github.com/jonaseck2/slaktforskning/tree/main/.claude/skills/performance-profiling
Command: npx skills add https://github.com/jonaseck2/slaktforskning --skill performance-profiling-jonaseck2

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

It helps you diagnose and resolve slow operations, CPU saturation, and apparent hangs in the Släktforskning Tauri app by turning guesswork into evidence from host and renderer CPU profiles.

Core Features & Use Cases

  • Renderer profiling (webview/UI layer): Use system webview inspection (Chromium DevTools or Safari Web Inspector) to find Vue/JS/layout/paint hotspots.
  • Host profiling (Rust/Tauri layer): Profile the Rust host process using tools like samply or cargo flamegraph to determine whether the time is in SQL/serialization/fs work.
  • SQLite bottleneck pattern recognition: Identify common query shapes (e.g., correlated NOT EXISTS, N+1 loops, and event_participants self-joins) and apply targeted query/index refactors after confirming with profiles.

Quick Start

Use performance profiling to analyze the slowdown in the specific operation by capturing a CPU trace first, then interpreting the widest frames to determine whether the bottleneck is renderer JS, Rust host work, or SQLite query patterns.

Frequently Asked Questions about performance-profiling

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

FAQPage Schema
How do I diagnose slow operations and CPU saturation in a Tauri app?▼

Diagnose slow operations and CPU saturation in a Tauri app by capturing an initial CPU profile, then interpreting the widest frames to isolate whether the bottleneck stems from renderer JavaScript, Rust host processing, or SQLite query patterns.

How do I profile the Rust host process in Tauri to find SQL or filesystem bottlenecks?▼

Profile the Rust host process in Tauri using tools like samply or cargo flamegraph to generate a CPU flamegraph, which determines whether execution time is spent in SQL execution, data serialization, or filesystem operations.

What causes N+1 query loops and correlated NOT EXISTS bottlenecks in SQLite?▼

N+1 query loops and correlated NOT EXISTS bottlenecks in SQLite are common query shapes that cause performance degradation, requiring targeted query refactoring and index adjustments after confirming the bottleneck with CPU profiles.

Can I use Chromium DevTools to profile webview rendering and UI layer hotspots in Tauri?▼

Yes, you can use Chromium DevTools or Safari Web Inspector for renderer profiling to find Vue, JavaScript, layout, and paint hotspots within the Tauri webview UI layer.

What is the best way to fix hanging-feeling operations and slow imports in a Tauri application?▼

The best way to fix hanging-feeling operations and slow imports is correlating renderer and Rust host CPU profiles with known SQLite bottleneck patterns, applying query pattern fixes and index adjustments validated by evidence.

Related Skills

Explore More Software Engineering Skills→
vanyastaffvanyastaff
1

rust-performance

Profile Rust code with flamegraphs and optimize hot paths.

Community
Advanced
89jobrien89jobrien
4

database-optimization

Optimize slow SQL queries and resolve N+1 problems in relational databases.

Community
Advanced
rakhnianskii9rakhnianskii9

perf-profile

Profile CPU, memory, and rendering paths in Godot 4.x projects.

Community
Advanced
kevindreekevindree

browser-testing-with-devtools

Inspect live DOM, console, network, and accessibility data via Chrome DevTools MCP.

Community
Advanced