Chatbot Excellence Blueprint — Architecture Principles & Vendor Slots
Durable reference for what makes a world-class agentic chatbot. Principles are permanent; vendor/model choices are pluggable and must be re-evaluated quarterly.
4 docs tagged with "performance"
View all tagsHNSW Vector Index on unified_rag_content.embedding
Decision
Investigate and Resolve Slow Database Queries
Diagnose slow Supabase queries with EXPLAIN ANALYZE, identify missing indexes, fix pagination issues (missing .range()), and resolve Supabase advisory warnings
Next.js 16 — Streaming Soft-404s and ISR Blockers
Verified: 2026-06-11. Two related Next.js 16 App Router production failures, found and fixed across PewSearch, ITW, and churchwiseai-web on 2026-06-09/10. Both are invisible in dev and in "build passes" checks — they only show in HTTP status codes and the prerender manifest.