Small correction: neo4j is limited to the resources of a single machine, but the database doesn't need to fit in RAM. You will see a significant slowdown once your data gets too big for RAM, but neo4j has put a fair amount of effort into efficient caching.