[Neo] MySQL vs. Neo4j in a Breadth-First Graph Traversal

2010-03-29 Thread Marko Rodriguez
Hi guys, Sorry if you have already seen this (Twitter, Gremlin mailing list, etc.), but for those that haven't, this is of potential interest to all you Neo4j users. http://markorodriguez.com/Blarko/Entries/2010/3/29_MySQL_vs._Neo4j_on_a_Large-Scale_Graph_Traversal.html Take care, Marko. http:

Re: [Neo] MySQL vs. Neo4j in a Breadth-First Graph Traversal

2010-03-29 Thread Laurent Laborde
Hu... I'm surprised. I expected the test to be unfair in favor of mysql for a simple graph traversal. In fact, i still think that with good mysql configuration and good sql tuning, mysql can be faster. Of course, if you add different kind of relationship, node property, relationship property a

Re: [Neo] MySQL vs. Neo4j in a Breadth-First Graph Traversal

2010-03-29 Thread Peter Neubauer
Yup, that is our assessment, too. On 1-3 joins there is a chance to optimize the queries in an RDBMS. But still you have indexes instead of references, and the overhead of serialization through the JDBC driver. Anyway, it even shows that Java based DBs are not necessarily slower than C based. Then

Re: [Neo] MySQL vs. Neo4j in a Breadth-First Graph Traversal

2010-03-30 Thread Laurent Laborde
On Tue, Mar 30, 2010 at 8:57 AM, Peter Neubauer wrote: > > MySQL degrades as the data volume increases, and as the depth > increases (at depth 5 MySQL just hangs). You used MyIsam ? InnoDB ? What about postgresql ? (which is not supposed to be faster than MyIsam, but usually faster than InnoDB)

Re: [Neo] MySQL vs. Neo4j in a Breadth-First Graph Traversal

2010-03-30 Thread Peter Neubauer
Not sure about the MySQL flavor, Marko has been doing the tests on his machine ... Cheers, /peter neubauer COO and Sales, Neo Technology GTalk: neubauer.peter Skype peter.neubauer Phone +46 704 106975 LinkedIn http://www.linkedin.com/in/neubauer Twitter http://twitter.co

Re: [Neo] MySQL vs. Neo4j in a Breadth-First Graph Traversal

2010-03-30 Thread Rick Bullotta
-- From: Laurent Laborde Sender: user-boun...@lists.neo4j.org To: Neo user discussions ReplyTo: Neo user discussions Subject: Re: [Neo] MySQL vs. Neo4j in a Breadth-First Graph Traversal Sent: Mar 30, 2010 3:11 AM On Tue, Mar 30, 2010 at 8:57 AM, Peter Neubauer wrote: > > MySQL degrades as th

Re: [Neo] MySQL vs. Neo4j in a Breadth-First Graph Traversal

2010-03-30 Thread Marko Rodriguez
Hi, > You used MyIsam ? InnoDB ? > What about postgresql ? (which is not supposed to be faster than > MyIsam, but usually faster than InnoDB) I used MyISAM. Marko. http://markorodriguez.com ___ Neo mailing list User@lists.neo4j.org https://lists.neo4