CODEWITHSUNDEEP
neo4jdatasetcypher
Gondil
Gondil

Reputation: 807

Neo4j input limit

I have large amount of movies and keywords related. I parsed a data text file with keywords to create nodes for every keyword. It is about 160k keywords, so 160k lines of create queries. I procedurally created text file with these queries. Then I browsed to localhost where I can manage my database. I dropped this file with that huge query there and executed it.

After few seconds it returned an error:

Neo.DatabaseError.General.UnknownFailure

I think it's due to size of query. I picked just few lines and then execute. Nodes were created. But when I picked about 500 lines, same error was returned. With about 450 lines it runs fine.

  1. Is there any way to execute such large queries in Neo4j? You understand that copy-paste 160k lines by about 450 lines at once is crazy even if that it is just a part of my database (need also movies and relationships).
  2. Is Neo4j(free version) limited in data stored in database?
  3. How should I manage my database? Is it ok to use that tool in browser or should I use some programming language to access database? If so what would be best way and how to do that?

Upvotes: 0

Views: 477

Answers (1)

Stefan Armbruster
Stefan Armbruster

Reputation: 39925

  1. Best practice for this kind of operation is to convert the data to be imported into csv format and then apply the LOAD CSV command from Neo4j browser.
  2. Neo4j community edition has the same capabilities in terms of capacity.
  3. Most people use the Neo4j browser as a developer tool to build their cypher queries. The queries then go into an application on whatever stack you prefer.

Upvotes: 2

Related Questions