IS2 Recent messages of a person

[Dtenwolde]

Very similar to IS6 #74, this query is slow to terminate and requires a lot of memory.

FROM GRAPH_TABLE (snb_projected
    MATCH p = ANY SHORTEST (person:Person WHERE person.id = 28587302328111)<-[mhc:Message_hasCreator]-(message:Message)-[ro:message_replyOf]-> *(post:Post)-[phc:post_hasCreator]->(originalPoster:Person)
    COLUMNS (message.id as mid, coalesce(message.content, message.imageFile), message.creationDate, post.id, originalPoster.id, originalPoster.firstName, originalPoster.lastName)
    ) tmp
    ORDER BY tmp.creationDate desc, tmp.mid desc

[Dtenwolde]

See ic2-analyze.txt

I believe the time tracking for the last BLOCKWISE_NL_JOIN is not correct, as 0.00 is not believable in this case

[github-actions[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.