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.