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.
