Hi Bill, there is a command called FIND REFERENCES ( http://orientdb.com/docs/last/SQL-Find-References.html) that does the trick. Take into consideration that it does a full scan of the database, because there is no other way to find link references, so it can take ages to finish on large datasets.
I suggest you to adopt one of the following approaches when using links: 1) use only schemaful link properties and create indexes on them, this way you will always know where links can be and you will have a quick way to query them 2) replace links with edges (graph model): they are bi-directional, so edge removal is a very cheap operation, automatically managed by the db engine Thanks Luigi 2015-08-06 15:24 GMT+02:00 Bill Blondin <[email protected]>: > When deleting a record that is pointed to by various related > LINK/LINKSET/LINKLIST pointers, what's the best way to delete those > pointers, as they will no longer be valid? > > From the scope of the record being deleted, there doesn't appear to be an > obvious way to determine what records are pointing to it, in order to > remove those pointers. > > Bill > > -- > > --- > 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.
