Ids are supposed to be globally unique, regardless of their label (again,
i'm not sure this is the best approach, but i thought it was the one that
made more sense), i'm not sure what kind of info i could provide so feel
free to ask...
Il giorno gio 7 feb 2019, 21:24 Eve Freeman <eve.fre...@gmail.com> ha
scritto:
> Whoops, "if so" should be "if not".
>
> On Thu, Feb 7, 2019 at 3:22 PM Eve Freeman <eve.fre...@gmail.com> wrote:
>
>> Are the ids unique to each label? If so, maybe you can merge on one
>> "inclusive" label and then add an additional category label, and then you
>> can have just one constraint. No idea what you're doing here, so giving my
>> best guess.
>>
>> On Thu, Feb 7, 2019 at 2:40 PM Andrea Balzoni <
>> andrea.balz...@keypartner.it> wrote:
>>
>>> That sounds like a lot of constraints or am i wrong?
>>>
>>> Il giorno gio 7 feb 2019, 20:19 Eve Freeman <eve.fre...@gmail.com> ha
>>> scritto:
>>>
>>>> Yes. You would need to add a constraint for each label + id combination.
>>>>
>>>> On Thu, Feb 7, 2019 at 1:57 PM Andrea Balzoni <
>>>> andrea.balz...@keypartner.it> wrote:
>>>>
>>>>> Sadly the ids i'm trying to add are not going to be necessarily
>>>>> unique, hence why i'm using merge. I think i grasped what a constrant is,
>>>>> but i cant say the same about indexes. So you are telling me that adding a
>>>>> constraint on ids would make the query faster? Sorry about questions that
>>>>> might sound stupid, but i'm fairly new to neo4j...
>>>>>
>>>>> Il giorno gio 7 feb 2019, 18:59 Eve Freeman <eve.fre...@gmail.com> ha
>>>>> scritto:
>>>>>
>>>>>> One other note--if you know these are unique ids, you can avoid using
>>>>>> merge, and just use create, which will be quicker still.
>>>>>>
>>>>>> On Thu, Feb 7, 2019 at 12:54 PM Eve Freeman <eve.fre...@gmail.com>
>>>>>> wrote:
>>>>>>
>>>>>>> Well, what a merge will do is check whether something exists before
>>>>>>> it creates it, "match or create". The match step will get linearly
>>>>>>> slower
>>>>>>> as it has to scan larger and larger lists of nodes on a label. If you
>>>>>>> add
>>>>>>> an index (at minimum), or unique constraint/node key (preferred,
>>>>>>> especially
>>>>>>> if you require uniqueness and will eventually have concurrent requests
>>>>>>> of
>>>>>>> this nature), it will be able to do the match step much quicker.
>>>>>>>
>>>>>>> On Thu, Feb 7, 2019 at 12:50 PM Andrea Balzoni <
>>>>>>> andrea.balz...@keypartner.it> wrote:
>>>>>>>
>>>>>>>> Honestly i heard of those, but i'm not using any. I'm quite new to
>>>>>>>> it, so i wasnt sure what their purpose is.
>>>>>>>>
>>>>>>>> Il giorno gio 7 feb 2019, 18:43 Eve Freeman <eve.fre...@gmail.com>
>>>>>>>> ha scritto:
>>>>>>>>
>>>>>>>>> What's your schema? Do you have a unique constraint or index on
>>>>>>>>> the labels + id you're merging on?
>>>>>>>>>
>>>>>>>>> Eve
>>>>>>>>>
>>>>>>>>> On Thu, Feb 7, 2019 at 12:23 PM <andrea.balz...@keypartner.it>
>>>>>>>>> wrote:
>>>>>>>>>
>>>>>>>>>> Hello everyone, i'm trying to MERGE thousands of nodes using
>>>>>>>>>> UNWIND and apoc procedures (for a dynamic label creation) using Java
>>>>>>>>>> Driver
>>>>>>>>>> as follows:
>>>>>>>>>>
>>>>>>>>>> String query =
>>>>>>>>>> "UNWIND $nodes AS n " +
>>>>>>>>>> "CALL apoc.merge.node([n.category], {id: n.id},
>>>>>>>>>> n) YIELD node RETURN node";
>>>>>>>>>> session.run( query, params );
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> My database contains something like 150k nodes divided by 16
>>>>>>>>>> labels and 130k relationships of the same type. It worked fine so
>>>>>>>>>> far, it
>>>>>>>>>> never failed to deliver, but now that i'm trying to create something
>>>>>>>>>> like
>>>>>>>>>> 4k new nodes and 5k new relationships at once it took more than 30
>>>>>>>>>> minutes.
>>>>>>>>>> I feel like it should be way faster than this.
>>>>>>>>>>
>>>>>>>>>> Am i doing anything wrong? Is it really supposed to be this slow?
>>>>>>>>>> Is there anything i can do to make this process smoother and to
>>>>>>>>>> improve
>>>>>>>>>> performances?
>>>>>>>>>>
>>>>>>>>>> Thanks in advance
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>> You received this message because you are subscribed to the
>>>>>>>>>> Google Groups "Neo4j" group.
>>>>>>>>>> To unsubscribe from this group and stop receiving emails from it,
>>>>>>>>>> send an email to neo4j+unsubscr...@googlegroups.com.
>>>>>>>>>> For more options, visit https://groups.google.com/d/optout.
>>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> You received this message because you are subscribed to the Google
>>>>>>>>> Groups "Neo4j" group.
>>>>>>>>> To unsubscribe from this group and stop receiving emails from it,
>>>>>>>>> send an email to neo4j+unsubscr...@googlegroups.com.
>>>>>>>>> For more options, visit https://groups.google.com/d/optout.
>>>>>>>>>
>>>>>>>> --
>>>>>>>> You received this message because you are subscribed to the Google
>>>>>>>> Groups "Neo4j" group.
>>>>>>>> To unsubscribe from this group and stop receiving emails from it,
>>>>>>>> send an email to neo4j+unsubscr...@googlegroups.com.
>>>>>>>> For more options, visit https://groups.google.com/d/optout.
>>>>>>>>
>>>>>>> --
>>>>>> You received this message because you are subscribed to the Google
>>>>>> Groups "Neo4j" group.
>>>>>> To unsubscribe from this group and stop receiving emails from it,
>>>>>> send an email to neo4j+unsubscr...@googlegroups.com.
>>>>>> For more options, visit https://groups.google.com/d/optout.
>>>>>>
>>>>> --
>>>>> You received this message because you are subscribed to the Google
>>>>> Groups "Neo4j" group.
>>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>>> an email to neo4j+unsubscr...@googlegroups.com.
>>>>> For more options, visit https://groups.google.com/d/optout.
>>>>>
>>>> --
>>>> You received this message because you are subscribed to the Google
>>>> Groups "Neo4j" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to neo4j+unsubscr...@googlegroups.com.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "Neo4j" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to neo4j+unsubscr...@googlegroups.com.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
--
You received this message because you are subscribed to the Google Groups
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
