Strategy for matching 6 million nodes

Hi @bent.s.lund

The first step is to create indexes like this.

CREATE INDEX equipment_index FOR (n:Equipment) ON (n.Manufacturer, n.Model);
CREATE INDEX product_index FOR (n:Product) ON (n.Manufacturer, n.Model);

The "CALL apoc.periodic.iterate(" works fine even for nearly 100 million data.

2 Likes