Paul, what is your actual use-case that you want to achieve with the graph database?
Just comparing them with SQL databases is not practical as both databases are optimized for different use-cases. This should return quickly though, but you forgot the colon before :WORKS_FOR so it will follow all relationship on all clients which might be many. > match (c: Client)-[:WORKS_FOR]->(co: Company) return c, co limit 10 perhaps you can also write it as: > match (c: Client) MATCH (c)-[:WORKS_FOR]->(co: Company) return c, co limit 10 Also here you miss the colons for relationship-types > (Client)-[:LIVES_IN]->(City) and [:WORKS_FOR]->(Company) HTH, Michael Am 23.06.2014 um 14:10 schrieb Paul Damian <[email protected]>: > Hey guys, > > I'm quite new to Neo4j and Cypher and I am using it to compare its > performance with a SQL database. I've loaded my SQL database into the graph > store which now has approx. 13 mil nodes and 13 mil relationships [I have > difficulties loading all the relationships]. The nodes are labeled Client, > City or Company. Obviously, a (Client)-[LIVES_IN]->(City) and > [WORKS_FOR]->(Company). There are about 11 mil Clients, 1 mil Companies and > 15K Cities. > I'm trying to run a command to find out 10 clients and the companies they > work for. I've used a query like this: > match (c: Client)-[WORKS_FOR]->(co: Company) return c, co limit 10 > However, it keeps returning Java heap space error. > I have already indexed the Id properties of the nodes. > Neo4j is installed on a vm with windows server 2012R2 Intel Xeon @ 2.27 GHz > and 8 GB of RAM. The graph db has over 30 GB (which is weird since the SQL > database that was used to populate the graph only has 13 GB). > What can I do to improve the query performance [and get it to execute]? > > Thanks > Paul > > -- > 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. -- 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.
