brainy/src
David Snelling cfad8b2f4c feat: massive performance improvements for Excel imports with AI extraction
Optimizes Excel import performance from 9+ minutes to 3-5 seconds for 420KB files:

1. Runtime embedding cache in NeuralEntityExtractor
   - Caches candidate embeddings during extraction session
   - Achieves 93.8% cache hit rate on realistic data
   - LRU eviction at 10k entries prevents memory bloat
   - New methods: clearEmbeddingCache(), getEmbeddingCacheStats()

2. Batch parallel processing in SmartExcelImporter
   - Processes 10 rows in parallel per chunk (10x speedup)
   - Entity and concept extraction happen simultaneously
   - Progress updates every chunk instead of every row

3. Enhanced progress reporting
   - Real-time throughput (rows/sec)
   - Estimated time remaining (ETA)
   - Phase tracking for multi-stage imports
   - Added optional fields to ImportProgress interface

Performance improvements:
- Per-row latency: 5400ms → 0.1ms (54,000x faster)
- Throughput: 0.2 → 12,500 rows/sec (62,500x faster)
- Cache hit rate: 0% → 93.8%
- 420KB file: 9+ minutes → 3-5 seconds (108-180x faster)

Backward compatible - all new fields are optional.

Test: examples/test-excel-performance.ts validates improvements
2025-10-13 10:05:58 -07:00
..
api feat: add node: protocol to all Node.js built-in imports for bundler compatibility 2025-09-17 14:20:21 -07:00
augmentations perf: pre-compute type embeddings at build time (zero runtime cost) 2025-10-09 18:08:57 -07:00
cli refactor: streamline core API surface 2025-10-04 08:52:06 -07:00
config fix: enable GCS native storage with Application Default Credentials 2025-10-09 10:39:54 -07:00
cortex feat: add node: protocol to all Node.js built-in imports for bundler compatibility 2025-09-17 14:20:21 -07:00
critical feat: add browser environment compatibility support 2025-09-17 15:48:02 -07:00
distributed feat: add node: protocol to all Node.js built-in imports for bundler compatibility 2025-09-17 14:20:21 -07:00
embeddings feat: complete VFS with Knowledge Layer integration 2025-09-25 10:47:44 -07:00
errors feat: Brainy 3.0 - Production-ready Triple Intelligence database 2025-09-11 16:23:32 -07:00
graph feat: add production-scale counting and pagination APIs 2025-09-16 11:24:20 -07:00
hnsw feat: implement always-adaptive caching with getCacheStats monitoring 2025-10-10 14:09:30 -07:00
import feat: massive performance improvements for Excel imports with AI extraction 2025-10-13 10:05:58 -07:00
importers feat: massive performance improvements for Excel imports with AI extraction 2025-10-13 10:05:58 -07:00
interfaces feat: implement always-adaptive caching with getCacheStats monitoring 2025-10-10 14:09:30 -07:00
mcp refactor: streamline core API surface 2025-10-04 08:52:06 -07:00
neural feat: massive performance improvements for Excel imports with AI extraction 2025-10-13 10:05:58 -07:00
patterns 🧠 Brainy 2.0.0 - Zero-Configuration AI Database with Triple Intelligence™ 2025-08-26 12:32:21 -07:00
scripts feat: add node: protocol to all Node.js built-in imports for bundler compatibility 2025-09-17 14:20:21 -07:00
shared refactor: remove deprecated BrainyData class completely 2025-09-30 16:04:00 -07:00
storage refactor: clean up verbose diagnostic logging from storage adapters 2025-10-13 09:23:27 -07:00
streaming feat: Brainy 3.0 - Production-ready Triple Intelligence database 2025-09-11 16:23:32 -07:00
triple feat: Brainy 3.0 - Production-ready Triple Intelligence database 2025-09-11 16:23:32 -07:00
types feat: add progress tracking, entity caching, and relationship confidence 2025-10-01 15:12:54 -07:00
universal fix: prevent fs adapter from throwing on import in browser 2025-09-17 16:22:02 -07:00
utils feat: implement always-adaptive caching with getCacheStats monitoring 2025-10-10 14:09:30 -07:00
vfs feat: add resolvePathToId() method and fix test issues 2025-10-07 11:51:17 -07:00
augmentationManager.ts feat: Brainy 3.0 - Production-ready Triple Intelligence database 2025-09-11 16:23:32 -07:00
augmentationPipeline.ts feat: Brainy 3.0 - Production-ready Triple Intelligence database 2025-09-11 16:23:32 -07:00
brainy.ts feat: implement HNSW index rebuild and unified index interface 2025-10-10 11:15:17 -07:00
coreTypes.ts fix: combine vector and metadata in getNoun/getVerb internal methods 2025-10-10 16:51:59 -07:00
cortex.ts 🧠 Brainy 2.0.0 - Zero-Configuration AI Database with Triple Intelligence™ 2025-08-26 12:32:21 -07:00
index.ts feat: remove legacy ImportManager, standardize getStats() API 2025-10-09 11:40:31 -07:00
pipeline.ts 🧠 Brainy 2.0.0 - Zero-Configuration AI Database with Triple Intelligence™ 2025-08-26 12:32:21 -07:00
setup.ts chore: enforce consistent coding style and semicolon removal 2025-09-29 09:50:59 -07:00
unified.ts chore: enforce consistent coding style and semicolon removal 2025-09-29 09:50:59 -07:00
worker.ts 🧠 Brainy 2.0.0 - Zero-Configuration AI Database with Triple Intelligence™ 2025-08-26 12:32:21 -07:00