How can I optimize this MATCH/RETURN query?

[and_manousakis]

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?

[intouch_vivek · Accepted solution]

Hi @and.manousakis,

Please go to below article

Neo4j Graph Database Platform – 10 Feb 16

Tuning Your Cypher: Tips & Tricks for More Effective Queries

Watch (or read) Mark Needham and Petra Selmer’s GraphConnect presentation on how to tune your Cypher queries for maximum effectiveness and speed.

specially Reduce Cardinality