Optimize Query Performance

[soovittt]

Description

Multiple useQuery hooks may cause N+1 queries and performance issues. Need query batching and caching.

Current State

• Multiple useQuery hooks in components
• May cause N+1 query problems
• No query batching
• No query caching strategy
• Repeated queries for same data

Files Affected

• All components using useQuery
• app/components/RunComparison.tsx - Multiple queries
• app/components/RunViewer.tsx - Multiple queries

Expected Behavior

• Query batching for related queries
• Query caching to avoid repeated requests
• Query deduplication
• Optimistic updates
• Query prefetching

Acceptance Criteria

• Implement query batching
• Add query caching
• Add query deduplication
• Add optimistic updates
• Add query prefetching
• Optimize existing queries
• Add performance monitoring
• Add tests