cancel
Showing results for 
Search instead for 
Did you mean: 

Fulltext Search with apoc.periodic iterate

lavanya_kannan
Graph Buddy

I am trying to run full text search on a property of each node (million of those) stored as a full text index:

CALL db.index.fulltext.createNodeIndex("alias_entity_names",["alias"],["name"]);

and extract the Lucene search score

CALL apoc.periodic.iterate("
	MATCH (a1:alias) 
	CALL db.index.fulltext.queryNodes('alias_entity_names', a1.name) YIELD node, score
	WITH a1, node, score  WHERE id(node) = id(a1)
    return a1, score 
	", "
	SET a1.lucene_score1 = score
	", {batchSize:500, parallel:true, iterateList:true})        
YIELD batches, total, errorMessages;

The periodic iterate call is running slow. Is there a better way to do this? Thanks.

Lavanya

0 REPLIES 0