[orientdb] Re: delete vertex not working with out where

2015-08-13 Thread alessandrorota04
Hi, Could you send me your database so that I can test it or tell me the type of property1. The previous function written in Java with JavaScript is the following: var g=orient.getGraph(); for(j=0;j3;j++){ g.command('sql','DELETE VERTEX MyVertex LIMIT 100'); g.commit(); } Regards,

[orientdb] Re: delete vertex not working with out where

2015-08-12 Thread alessandrorota04
Hi, I tried to cancel 3,000,000 of vertices with this java code and I had no problems. for(int j=0;j3;j++){ g.command(new OCommandSQL(DELETE VERTEX MyVertex LIMIT 100)).execute(); g.commit(); } Let me know how it goes. Regards, Alessandro. -- --- You received this message because you

[orientdb] Re: delete vertex not working with out where

2015-08-12 Thread ropeladder
I'm using the Orient Studio browse page for basic SQL commands and writing functions in Javascript when necessary (since I don't know any Java), but I'm assuming that's not going to make a difference for memory errors or command parsing, right? Also earlier I said that DELETE VERTEX MyVertex

[orientdb] Re: delete vertex not working with out where

2015-08-11 Thread ropeladder
Thanks--I just tried this and Orient accepts the query, but it still gives me an OutOfMemoryError: GC overhead limit exceeded eventually. On Monday, August 10, 2015 at 8:46:32 AM UTC-4, alessand...@gmail.com wrote: Hi, try to use DELETE VERTEX MyVertex LIMIT 100 instead of DELETE VERTEX

[orientdb] Re: delete vertex not working with out where

2015-08-10 Thread alessandrorota04
Hi, try to use DELETE VERTEX MyVertex LIMIT 100. Alessandro -- --- 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 orient-database+unsubscr...@googlegroups.com. For

[orientdb] Re: delete vertex not working with out where

2015-08-10 Thread alessandrorota04
Hi, try to use DELETE VERTEX MyVertex LIMIT 100 instead of DELETE VERTEX MyVertex BATCH 100. Alessandro -- --- 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

[orientdb] Re: delete vertex not working with out where

2015-08-10 Thread alessandrorota04
Hi, if you want to delete all vertexes of a class use this command truncate class MyClass unsafe Regards, Alessandro -- --- 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

[orientdb] Re: delete vertex not working with out where

2015-08-10 Thread ropeladder
Thanks, I'll try that. Do you know if I am using the BATCH command correctly? I'm also trying to delete roughly half of an 8 million-vertex class. On Monday, August 10, 2015 at 3:31:40 AM UTC-4, alessand...@gmail.com wrote: Hi, if you want to delete all vertexes of a class use this command