Performance Tuning

[storage]
block_cache_size = "8GB"      # 25% of RAM
compression = "lz4"           # Fast compression
max_open_files = 10000        # Increase for large datasets

[storage.rocksdb]
max_background_jobs = 8       # Match CPU cores
write_buffer_size = "128MB"   # Larger for write-heavy workloads
max_write_buffer_number = 4

[memory]
query_cache_size = "2GB"      # Cache frequently used queries
result_cache_size = "1GB"     # Cache query results

[server]
max_connections = 1000        # Concurrent connections
connection_timeout_ms = 30000

-- Index on user email for fast lookups
CREATE INDEX ON :User(email)

-- Composite index
CREATE INDEX ON :Post(author_id, timestamp)

curl http://localhost:7474/admin/indexes

# Good: Plan cached
graph.query("MATCH (u:User) WHERE u.age > $age RETURN u", {'age': 25})

# Bad: Reparse every time
graph.query("MATCH (u:User) WHERE u.age > 25 RETURN u")

-- Always use LIMIT
MATCH (u:User) RETURN u LIMIT 100

EXPLAIN MATCH (u:User)-[:KNOWS*2..3]->(f) RETURN f

-- Bad: Cartesian product
MATCH (u:User), (p:Post) WHERE u.id = p.author_id

-- Good: Direct relationship
MATCH (u:User)-[:POSTED]->(p:Post)

# Query performance
curl http://localhost:7474/admin/slow-queries

# Storage usage
curl http://localhost:7474/admin/stats

# Create test data
python scripts/generate-test-data.py --nodes=1000000

# Run benchmark
python scripts/benchmark.py --queries=10000