How can I optimize this MATCH/RETURN query?

Hi guys

Any pointers/advice on how to optimize/parallelize this query?

MATCH (src:Address)-[:REDEEMED]->(ip:IncomingPayment)-[:INCOMING_PAYMENT]->(tx:Transaction)-[:SENT_COINS]->(op:OutgoingPayment)-[:WAS_SENT_TO]->(dst:Address)
RETURN src.AddressID as src, dst.AddressID as dst, tx.Time as timestamp, tx.Hash as txHASH, ip.Value as inValue, op.Value as outValue
ORDER BY timestamp ASC

I've tried apoc.periodic.iterate but it doesn't yields results. Any suggestions?

Hi @and_manousakis,

Please go to below article

specially Reduce Cardinality