hello! i was using create/merge to insert data in an auradb instance. but it takes a long time. are there better ways to do this? i read something about load csv, but we can't do this with local files.
@infraplataforma
hard to say exactly
Importing data - Neo4j Aura describes how to import data,
it should be noted however that MERGE is a create or update. For it to be an update it has to find the node/rel to update. If it is MERGEing on a node than you are going to want to index on the label/property used to identify said node.
For performance reasons, creating a schema index on the label or property
is highly recommended when using MERGE. See Create, show, and delete
indexes for more information.
thanks for it, im searching for the fastest because i have to insert millions of nodes and rel, but a lot of ways to do this doens't work for aura db.
millions of creates are just millions of writes. merge however as previously stated will do a lookup to see if said node needs to be created or updated.
is the source data in a csv or similar? if not then?
can be. from a db, using python, i transform in a dataframe and then in a csv.