Is there a benchmark performance for openCypher query vs sql join query for data in SAP HANA Graph?

[sameerk20]

Hi All , 

Basically  we are evaluating what kind of performance gain we can expect on using open cypher query instead of simple sql joins .

We are mainly focusing on retrieval time for filtering in 1Million-10Million rows and around 500-1000 columns. 

Also is there a performance impact on using homogenous graph and heterogenous graph . If yes are there any readings for the same ?

Help is highly appreciated.

[mfath]

Hej, basically an openCypher query is translated into SQL operations under the hood. So you won't see any performance gains for these type of declarative queries. The story is different if you run graph procedures using "GraphScript". To accelerate graph traversals, index structures are created under the hood. This makes things like shortest path, reachable vertices etc. really fast. If you provide more details on the "filtering logic" you would like to apply and the data this is executed on, we might be able to advise.