Hi, Can someone help me in profiling the query below. I want to decrease the time it takes to execute.
Query: MATCH path=((a:Account {id:73})-[*3..5]-(a))
RETURN max(REDUCE(s = 0, r IN relationships(path) | s + r.baseAmount)) AS amt_max
How to synchronise my Postgre SQL database which is running on AWS RDS with the Neo4j instance running on EC2. The data should be synchronised in real time. For every new entry added to the SQL database a node should be created on my graph database.
(Account)-[transfers]->(Account) is the underlying schema.
I am trying to find the cyclic paths where the accounts involve in, along with the total amount which is being involved in the cycle. baseAmount is the property of the [transfers] relation.
Thank you all for the response, I have integrated Amazon Kinesis to create the data stream along with Lambda to trigger the Cypher query to push it into Graph database and it is working fine.
