[Neo4j] Expected performance question

2011-11-09 Thread Hans Birkeland
Hi, My team has been experimenting with using neo4j for dependency tracking. For one of our scenarios we have run into performance issues and are wondering if this is expected given the data, or if we are doing something wrong. Our test data consists of ~370k nodes and 4.1M relationships. Some

Re: [Neo4j] Expected performance question

2011-11-09 Thread Andres Taylor
Hi Hans, First of - we have so far spent very little time so far making Cypher awesome from a performance standpoint. Most of the energy has been put into growing the syntax and expanding the feature set of Cypher. The next version will hopefully involve a lot of performance work, and that will

Re: [Neo4j] Expected performance question

2011-11-09 Thread Hans Birkeland
Thanks for the quick reply! :) This is the query: start n=node(159178) match n-[*1..4]-x return count(*) Hans -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/Expected-performance-question-tp3492892p3492924.html Sent from the Neo4j Community Discussions

Re: [Neo4j] Expected performance question

2011-11-09 Thread Mattias Persson
Also, support for these heavy nodes with many relationships on them is being worked some on so that you can get relationship count per type/direction immediately instead of iterating over them, as well as only loading relevant relationships instead of all. In the meantime it would be better to

Re: [Neo4j] Expected performance question

2011-11-09 Thread Hans Birkeland
Ah sorry, I should have clarified - in the final application we will want to retrieve the nodes. The reason we were just returning count(*) for the tests is that returning a large number of nodes in the web console proved less than ideal. :) -- View this message in context:

Re: [Neo4j] Expected performance question

2011-11-09 Thread Michael Hunger
Oh, and cypher supports streaming (as long as you don't sort/aggregate). So that won't take up your memory. I would love if you could try that just using plain java code and iterating over the node-results and provide us with your performance numbers then. Please make sure to run the test more

Re: [Neo4j] Expected performance question

2011-11-09 Thread Andres Taylor
On Wed, Nov 9, 2011 at 9:28 AM, Hans Birkeland han...@funcom.com wrote: Thanks for the quick reply! :) This is the query: start n=node(159178) match n-[*1..4]-x return count(*) Good to know. The reason you are getting duplicates is because you'll get the same node in x multiple time - there