Fastest way to check if a RID is from a Vertex or an Edge

[André Toscano]

Hi guys, since now I was just watching the discussions.

I have I doubt that: What is the fastest way to ensure that a RID is from a vertex or an edge?

I was doing:

select from V where @rid = #<some_rid>

If I get the record it will be a vertex. This is a very expensive query, almost 2s in my system.

This is much faster:

select from #<some_rid> where @class = 'V' or @class in (SELECT name from (select expand(classes) from metadata:schema) where 'V' in superClasses)

 

This is executed in 40ms

But if I ask directly for the RID:

select from #<some_rid>

It takes 10 to 20ms

My ask is if there is a faster way (below of 40ms) to check the RID object type.

Best regards 

André Emilio Toscano

[Ivan Mainetti]

Hi,

use this 

select from <rid> where @this instanceof 'V'  --> to verify whether it's a Vertex
select from <rid> where @this instanceof 'E'  --> to verify whether it's an Edge

[André Toscano]

Perfect Ivan, this query executes in 10 to 20ms.

Thank you very much.

Best regards

André