I'm constructing a neo4j db from various sources with a c# script runing on local and connecting to neo4j with the official bolt driver. When creating the db in localhost it takes around 3 minutes to create both nodes and relationships but when connecting to a server hosted on Azure, just creating the nodes takes one hour and half.
Some metrics :
~370k nodes
local computer : i7 with 16g ram and ssd
remote computer : Azure Debian VM Standard_DS2
currently sending 1000 queries per transactions
I have indexes on all the node Ids
Azure metrics :
I can understand that it won't be as fast as creating a db on localhost but can't find the reason for such a difference.
Thanks!
EDIT
Its really classic creation queries like :
MERGE (n:NodeArt {id:$id})
ON CREATE SET n.nature = $nature, n.dateDebut = $dateDebut, n.dateFin = $dateFin
I use the 'out of the box' config with heap size and page cache size dynamically calculated.