March 2026 monthly summary for tolgee-platform focused on performance and scalability improvements. Delivered two major optimizations that reduce latency and DB load, enabling faster dashboards and translation-related workflows. Key changes: - Memoization in PromptLazyMap to cache lazy evaluations and prevent duplicate SQL queries, significantly reducing production call volume and latency. - Refactor of language statistics retrieval to a single native SQL query using two MATERIALIZED CTEs, replacing a heavy Criteria-based path and dramatically cutting query times. Impact: Production query times dropped from ~20s to ~2s for language stats and related data paths; fewer duplicate translations queries; improved reliability and output stability for prompt rendering and language dashboards. Tests and quality: Added unit tests around lazy evaluation behavior and the new language-stats path to ensure at-most-once evaluation and correct results. Technologies/skills demonstrated: SQL performance optimization (native queries, MATERIALIZED CTEs), caching and memoization, refactoring from ORM Criteria API to native SQL, test-driven development, performance profiling, and release-note documentation.