Fixed
Cloudflare D1 Drift Detection Performance (Issue #264)
Fixed slow/failing queries in hybrid backend drift detection with 10-100x performance improvement.
Root Cause: get_memories_updated_since() used slow ISO string comparison (updated_at_iso > ?) instead of fast numeric comparison on indexed column.
Fix: Changed WHERE clause to use indexed updated_at column with numeric comparison (updated_at > ?).
Performance Impact:
- 10-100x faster queries
- Eliminates D1 timeout/400 Bad Request errors on large datasets
- Proper use of database indexes for optimal query performance
Affected Function: CloudflareStorage.get_memories_updated_since() (lines 1638-1667)
Location: src/mcp_memory_service/storage/cloudflare.py
Credit: Root cause analysis by Claude Code workflow (GitHub Actions)
Full CHANGELOG: https://github.com/doobidoo/mcp-memory-service/blob/main/CHANGELOG.md