Hey, just wondering, why is cypher query on community edition is very slow?
I tried using profile and explain, followed the practice to name the label whenever I can. In addition, I have also added an index and constraint. So I am wondering whether the computation is very slow, or is it just the community edition.
Data ingestion from csv is really fast by the way. And the query I'm trying now is this:
MATCH (c:user)-[r:trx]->(p:user) WITH r.created_trx_date AS date, c.user_id as user, SUM(r.amount) AS total_transaction_amount WHERE date > date('2019-03-01') AND total_transaction_amount >= 10000000 RETURN wallet, total_transaction_amount ORDER BY total_transaction_amount DESC LIMIT 25
I have about 24,309,729 nodes and 156,617,848 relationships, currently 11 node labels, and 10 relationship labels.
I feel that the
where clause is the reason it is very slow. I want to write a more complex cypher query, but if it will take very long, I am concerned that I cannot do real-time analysis on this. Can someone shed some light in query computation for me please?