Can you share the concrete queries? Your Cypher query is not valid cypher. Do you have an index / constraint on the name property? And you should use a label.
create index on :User(name); or create constraint on (u:User) assert u.name is unique; I have a database of 2M users and run these queries with default settings on Neo4j 3.0-RC1: e.g. MATCH (n:User) WHERE exists(n.name) SET n.updated = " 2016-11-29T16:48:26.000Z"; Set 1100000 properties, statement executed in 20699 ms. MATCH (n:User) RETURN * LIMIT 10000; Returned 10000 rows in 501 ms, displaying first 1000 rows. MATCH (n:User) WHERE n.name starts with "name100000" RETURN *; Returned 4 rows in 5 ms. not sure what your memory config is. On Mon, Apr 18, 2016 at 5:24 AM, Kenji Fnu <[email protected]> wrote: > Hi guys, > I've been testing CRUD methods on neo4j and mysql. honestly i was > impressed by how fast neo4j insert process works.. it beats the sql by a > huge margin (approx 20ms vs 358ms) while delete process is only a tiny > difference. > but I wonder why select and update process in neo4j was less superior by > plenty? is it something that i do wrong or is it supposed to be its > weakness? > > this is the scenario: > > sql and neo4j have about 1.1M records > update using sql with (UPDATE table SET date NOW() WHERE name != NULL) in > 5579 ms > update using neo4j with (MATCH (n {name != null}) SET n.updated = > "2016-11-29T16:48:26.000Z") in xxx ms (still running and its been about 20 > minutes) > and > > -----Neo4j----- > Total select time for spesific user (3 records found) : 3139 milliseconds > Total select time for any users limit 10000 : 71995 milliseconds > -----MySql----- > Total select time for spesific user (3 records found) : 1210 milliseconds > Total select time for any users limit 10000 : 15431 milliseconds > > > thanks > > > -- > 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.
