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.
