Orient DB poor traversal performance while looking for depth upto 6.

[kaintharinder]

Hi @luigidellaquila , @Laa

I have the below setup in orientDB.

Relationship

Page ----child (one to one)---->Instance
Instance ------ targets (one to Many) ----> Segment
Instance ------ embeds (one to Many) ----> Fragment
Fragment ----- child (one to one) ------> Fragment Instance
Fragment Instance ----- targets (one to many)----> Segment

And I have one index on the property uuid for Page Vertex.

Query : SELECT @Rid,type FROM (TRAVERSE out() FROM (Select @Rid from Page where uuid = '2b7b1df1-6ee5-40b8-81d8-f0d1b53fc7fc'))

I need to get the full traversal (screenshot below ) from the above node and only need the rid and type (property) in another vertices.

For simple calls , it returns response under 20ms , but when put under of 100 TPS, the latency jumps to 900ms.