> hi, guys,
>
thx a lot for your help 
but unfortunately I don't have time right now to do the benchamark 
completely

What I found out is that with the querry "friend of friends" at level 5, 
Neo4J is faster than mysql.

I used the standford dataset from facebook to populate my db : 
 http://snap.stanford.edu/data/egonets-Facebook.html

The queries are 

Neo4j 

*MATCH* *(*n*{*id *:* *{*id*}})-[:*CONNECTED***1..5*]-(*friend_of_friend*)* 

*RETURN* *distinct* friend_of_friend*.*id

Mysql

*SELECT* *distinct* uid2

  *FROM* edge

 *WHERE* uid1 *IN* *(*

       *SELECT* uid2

         *FROM* edge

        *WHERE* uid1 *in* *(* *SELECT* uid2

                        *FROM* edge

                        *WHERE* uid1 *in* *(*  *SELECT* uid2

                                         *FROM* edge

                                         *WHERE* uid1 *in*  *(*   *SELECT* 
uid2

                                                            *FROM* edge

                                                            *WHERE* uid1 
*= *?

                                                         *)*

                                       *)*

                       *)*

       *);*


-- 
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 [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to