optimization▌

Universal SQL performance optimization across MySQL, PostgreSQL, SQL Server, Oracle, and other databases. \n \n Covers query analysis, index strategy design, subquery optimization, and JOIN tuning with before/after examples for each technique \n Addresses common anti-patterns including SELECT *, function calls in WHERE clauses, inefficient pagination, and correlated subqueries \n Provides database-agnostic guidance on batch operations, temporary tables, covering indexes, and partial indexes \n I

Profile and optimize Python code using cProfile, memory profilers, and performance best practices. \n \n Covers CPU profiling with cProfile, line-by-line profiling with line_profiler, memory tracking with memory_profiler, and production profiling with py-spy \n Includes 20+ optimization patterns: list comprehensions, generators, string concatenation, dictionary lookups, NumPy vectorization, caching, multiprocessing, and async I/O \n Provides database optimization techniques including batch opera

Memoization, code splitting, and virtualization patterns for optimizing React application performance. \n \n Covers four core optimization techniques: memoization (React.memo, useMemo, useCallback), code splitting with lazy/Suspense, virtualization for large lists, and state management strategies to minimize render cascades \n Includes React 18+ concurrent features (useTransition, useDeferredValue) for improved responsiveness and perceived performance \n Provides profiling workflow using React D

Context optimization extends the effective capacity of limited context windows through strategic compression, masking, caching, and partitioning. The goal is not to magically increase context windows but to make better use of available capacity. Effective optimization can double or triple effective context capacity without requiring larger models or longer contexts.

Context optimization extends the effective capacity of limited context windows through strategic compression, masking, caching, and partitioning. The goal is not to magically increase context windows but to make better use of available capacity. Effective optimization can double or triple effective context capacity without requiring larger models or longer contexts.

Guides GEO/AEO strategy for AI search visibility. GEO optimizes content for ChatGPT, Claude, Perplexity, and AI search summaries (Google AI Overviews, Bing Copilot, Yandex Search with AI)—getting cited in AI-generated answers rather than ranking in traditional SERPs. See serp-features for AI search as SERP features; featured-snippet for snippet optimization that overlaps with AI Overviews.

Complete App Store Optimization toolkit for researching, optimizing, and tracking mobile app performance across Apple App Store and Google Play Store. \n \n Covers keyword research, competitor analysis, metadata optimization (titles, descriptions, keywords), and visual asset strategies with platform-specific character limit validation \n Includes review sentiment analysis, rating improvement tactics, and A/B testing frameworks for continuous conversion optimization \n Provides ASO health scoring

Identify and quantify Azure cost savings through resource analysis, utilization metrics, and actionable optimization recommendations. \n \n Discovers orphaned resources (unattached disks, unused NICs, idle gateways) and over-provisioned services using Azure Quick Review scans \n Queries actual costs from Azure Cost Management API and utilization data from Azure Monitor to support rightsizing recommendations \n Generates prioritized optimization reports with estimated savings, validated pricing,

Production patterns for optimizing Apache Spark jobs including partitioning strategies, memory management, shuffle optimization, and performance tuning.

Production patterns for Bazel in large-scale monorepos.