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.
