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.

Reply via email to