I'm new at the Graph DataBase world and also Neo4J.
Currently, I want to try to insert a bunch of data into my Database via multiple large cypher statements.
Whats the best way to generate this cypher statements. (Currently I have writing time of ~120 seconds for each dataset, but read more details below)
I want to compare in my thesis Graph database vs. Relational database for a specific use case, where multiple components are linked together, For that I have created a big datamodel in C#.
Main points I want to check first are the reading/writing times in graph / relational database (with different steps (200 / 400 / 800 / 2000 / 4000 ....) .
After generating such a model I have a method which generates me a big cypher statement where I do multiple Merge Statements and create all nodes / relationships which are necessary.
(currently ~300-500 Lines of cypher statement)
This cypher statement is then send via C# SDK to the graph database to store the data.
I can also provide an example code, where you can try it yourself, and give me direct feedback to the created query.
I would be really happy for any hints / help / feedback to my query.
(provided query take > 60 Seconds to be stored in a fresh database, also with unique indices on each label)