optimization▌

Production patterns for optimizing Bazel builds in large-scale monorepos. \n \n Covers WORKSPACE configuration, .bazelrc tuning, remote caching/execution setup, and platform-specific build constraints \n Includes templates for TypeScript and Python libraries, custom Docker rules, and dependency analysis via Bazel query \n Provides performance profiling techniques, memory optimization strategies, and best practices for fine-grained targets and visibility enforcement \n Addresses monorepo patterns

Reduce cloud spending across AWS, Azure, GCP, and OCI through rightsizing, reserved capacity, and cost governance. \n \n Covers four optimization pillars: visibility (tagging, dashboards, alerts), rightsizing (utilization analysis, auto-scaling), pricing models (reserved instances, spot/preemptible, savings plans), and architecture patterns (serverless, managed services, tiered storage) \n Includes cloud-specific strategies: AWS reserved instances and savings plans (30–72% savings), Azure hybrid

Comprehensive DAX formula analysis and optimization with performance, readability, and best-practice guidance. \n \n Analyzes formulas across four dimensions: performance bottlenecks, readability clarity, best-practice compliance, and maintainability challenges \n Provides step-by-step optimization strategy including variable usage opportunities, function replacements, and context optimization techniques \n Delivers refactored formulas with improved structure, error handling via DIVIDE and BLANK

Master SQL query optimization, indexing strategies, and EXPLAIN analysis to eliminate slow queries. \n \n Covers EXPLAIN plan analysis with key metrics (Seq Scan, Index Scan, cost, rows, execution time) and five index types (B-Tree, Hash, GIN, GiST, BRIN) for different query patterns \n Includes five core optimization patterns: eliminating N+1 queries, cursor-based pagination, efficient aggregation, subquery transformation, and batch operations \n Provides advanced techniques like materialized v

Diagnose and fix performance bottlenecks across React frontends and database backends. \n \n Covers frontend optimization: React.memo, useMemo, useCallback, lazy loading, code splitting, image optimization, and bundle analysis \n Includes backend strategies: N+1 query fixes, database indexing, Redis caching, and API compression \n Provides measurement tools and workflows using Lighthouse, Web Vitals, and webpack-bundle-analyzer \n Emphasizes profiling first, incremental improvements, and continu

Optimize cloud storage costs and performance across multiple cloud providers using compression, intelligent tiering, data partitioning, and lifecycle management. Reduce storage costs while maintaining accessibility and compliance requirements.

Build, write, and optimize high-converting landing pages combining proven copy frameworks, the 11-essential-elements structure, and a clear creation workflow.

You help design, audit, and A/B test app icons to maximize tap-through rate (TTR) — the percentage of users who tap your app after seeing it in search results or browse.

$22

Analyze SQL queries to identify performance bottlenecks and implement optimization techniques. Includes query analysis, indexing strategies, and rewriting patterns for improved performance.