Thanks, Tried following query. Took 268.921997 sec(s) to delete 100k records !!
delete edge worksAt where @rid< #15:100000 I get following "TIP" in server log while deleting ! [TIP] Query 'SELECT FROM worksAt WHERE @rid < #15:100000' fetched more than 50000 records: to speed up things..... I will delete rest of the records now in batch of 100k. On Tuesday, 9 June 2015 15:35:06 UTC+5:30, Andrey Lomakin wrote: > > Hi, > Could you split removal of 600k records by several transactions with 100k > records ? > > On Tue, Jun 9, 2015 at 1:03 PM Kapil Ranade <[email protected] > <javascript:>> wrote: > >> Do I have any way to delete lot of edge records without corrupting other >> data? >> >> >> On Tuesday, 9 June 2015 15:17:31 UTC+5:30, Kapil Ranade wrote: >>> >>> Version: orientdb-community-2.1-rc3 >>> >>> I have an edge class with about 600k records. I just want to remove all >>> the records and create new edges. >>> >>> I cannot use "drop" or "truncate" as it says it can result in broken >>> records. Use unsafe. >>> >>> If I try to delete these 600k records OrientDB gives OutOfMemory error >>> and creates a heap dump. >>> >>> Any solution to this problem? 600k are NOT a lot of edges. >>> >> -- >> >> --- >> 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] <javascript:>. >> 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.
