Fixed. Now the CREATE EDGE command supports BATCH, like MOVE VERTEX. By default now is 100, to allow to run even with low RAM.
Docs are updated too: http://orientdb.com/docs/last/SQL-Create-Edge.html. Best Regards, Luca Garulli Founder & CEO OrientDB <http://orientdb.com/> On 21 September 2015 at 18:21, Luca Garulli <[email protected]> wrote: > Hi, > I've just created this issue: > https://github.com/orientechnologies/orientdb/issues/4993 > > Best Regards, > > Luca Garulli > Founder & CEO > OrientDB <http://orientdb.com/> > > > On 17 September 2015 at 03:12, MV-dev1 <[email protected]> wrote: > >> I'm trying to create edges from data that's already in my database. >> >> I've tried exhaustively in. >> >> 1) SQL (browse or console) >> 2) Java api >> 3) JavaScript api but much less than with above >> >> Something like... >> >> *CREATE EDGE studies FROM (SELECT FROM person WHERE person.age < 20 AND >> out('studies').size() == 0) TO #15:1* >> >> And let's say I have 100M rows.... >> >> I crash because of the GC, I crash the heap, I crash because..... My >> debug console looks like I'm watching the Matrix -- it's always been a >> little disconcerting for me to see this for what should be simple requests. >> >> I can add a limit and it will go further but I'd have to call it 100k >> times to get everything completed and that would take 2 days based on the >> performance that I see. >> >> CREATE EDGE studies FROM (SELECT FROM person WHERE person.age < 20* AND >> out('studies').size() == 0* *LIMIT 10000*) TO #15:1 >> >> And calling it a bunch of times in console crashes the GC so that I have >> to stop and restart. >> >> *Is there another way to do this? Suggestions on my query? Suggestions >> on some optimization?* >> >> V2.1.1 - 16 GB RAM >> >> -- >> >> --- >> You received this message because you are subscribed to the Google Groups >> "OrientDB" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> For more options, visit https://groups.google.com/d/optout. >> > > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
