We are working with the latest 3.1 version, we have a database of around 3.5M nodes and 100M relationships. Doing some basic queries is very slow that makes the application unusable.
neo4j-sh (?)$ profile MATCH (n1:`Club`)<-[r1:CLUB]-(n:`Player`) WHERE n.`international` = true RETURN COUNT(*) AS `Count`; +---------+ | Count | +---------+ | 2181771 | +---------+ 1 row 28676 ms Compiler CYPHER 3.1 Planner COST Runtime INTERPRETED +-------------------+----------------+---------+---------+-------------+-----------------------------------------------+ | Operator | Estimated Rows | Rows | DB Hits | Variables | Other | +-------------------+----------------+---------+---------+-------------+-----------------------------------------------+ | +ProduceResults | 1027 | 1 | 0 | Count | Count | | | +----------------+---------+---------+-------------+-----------------------------------------------+ | +EagerAggregation | 1027 | 1 | 0 | Count | | | | +----------------+---------+---------+-------------+-----------------------------------------------+ | +Filter | 1054596 | 2181771 | 4872405 | n, n1, r1 | n.international == { AUTOBOOL0} AND n:Player | | | +----------------+---------+---------+-------------+-----------------------------------------------+ | +Expand(All) | 2445865 | 2445865 | 2445868 | n, r1 -- n1 | (n1)<-[r1:CLUB]-(n) | | | +----------------+---------+---------+-------------+-----------------------------------------------+ | +NodeByLabelScan | 3 | 3 | 4 | n1 | :Club | +-------------------+----------------+---------+---------+-------------+-----------------------------------------------+ Total database accesses: 7318277 There are around 2.3M players and 3 clubs. It's taking 28secs the first time, then in takes around 9-10 secs. It's really annoying because it's a very simple query. Is there anything we are doing wrong? Is this something we can do about or it's the expected behaviour? This is running on a 16gbRAM machine, getting more RAM is the only way to improve it? Thanks, Matias. -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.