Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.
02-11-2020 10:38 PM
Hi All,
I have a large set of company names which I need to store in graph data base. The count of company names can be considered as 1,00,000 for now and which may increase overtime.
For now I have created a node named 'company' with 88 company names in the property of that node as list. Is this the right way to store multiple company names in a graph database? I am worried because the number of company names may increase to more than 1,00,000 and further.
What is the best way to store the company names in graph database so that my fetch query would be faster and give better performance?
Note that my graph database has other nodes and relationships connecting to the company node.
Please help me on the best way on how to store so many company names in a single database without impacting performance.
02-11-2020 11:16 PM
You need to store each company as a separate node with property 'name'(or anything you prefer) and node labelled as 'Company' .
Do you have any other node types in your graph?
02-11-2020 11:19 PM
Yes I do have other node types as well like the company node.
02-12-2020 12:54 AM
ok , try to design in such a way that each entity is considered as node type and each node will have a unique property which is company name in case of company node
02-12-2020 01:08 AM
So that means, for each company name I will have to create a single node with name property as that company name. So say for 50000 distinct companies I will have 50000 nodes of type company. Right?
02-12-2020 01:16 AM
right.
That's how you would ideally design a node in graph.
All the sessions of the conference are now available online