AndymickandClaude Haiku 4.5
2dddf7d27a
Feat: Performance optimization and UI improvements
- Add database indexes for category, collection, and product queries (7 indexes)
- Implement in-memory caching with 5-minute TTL for categories and collections
- Convert Personalised dropdown to hierarchical sections matching Products dropdown
- Fix Reveal component React hook initialization with mounted state
- Fix Prisma query validation errors (include + select conflicts)
- Optimize product page queries to use selective field selection
- Add edit functionality for categories with parent category and visibility toggles
Performance improvement: 27-31s → 17-18s page load time (~40% faster)
Co-Authored-By: Claude Haiku 4.5 <noreply@anthropic.com>