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