Hi everyone,
I'm pretty new to Neo4j and have been playing around with social graph
data using Neo4j.rb and Gremlin. Stats follow:
6.2 million nodes
73 million relationships
The two main types of nodes are Users and Items. Users -[Friend]->
Users and Users -[Like] -> Items. Users and Items have IDs and there's
an index on these IDs. I've been have some issues with traversal
speed. Queries like
a =[:]
g.v(*user node
id*).out('Item#likes').in('Item#likes').out('Item#likes').groupCount(a)
(this example was taken from
https://github.com/tinkerpop/gremlin/wiki)
take minutes. I think I might have not created necessary indices or
the right ones perhaps? Users generally have 30-40 outgoing Like edges
and 300 Friend edges, while Items can have >>6000 incoming Like
edges.
Any help/pointing in the right direction for me to fill in graph DB
knowledge gaps is much appreciated. Thanks in advance!
-Courtney