[GitHub] [incubator-age] Paxxxxxv-Dmitry commented on issue #195: Variable Length Edges feature does not scale well with the length of the path

[GitBox <gi...@apache.org>]

Paxxxxxv-Dmitry commented on issue #195:
URL: https://github.com/apache/incubator-age/issues/195#issuecomment-1064846731


   Thanks for the answer. I will search ways to limit queries. I'm glad to hear that you work on some performance improvements.
   
   I have another one performance question about Variable Length Edges feature -
   [*3] AND ()-[]->()-[]->()-[]->() are the same. Am I right?
   
   [*3] query works much more faster than ()-[]->()-[]->()-[]->() and I don't understand why.
   
   ```
   SELECT * FROM cypher('graph', $$
   MATCH (z:type1)-[*3]->(b:type2 {ci_sm_id: 'CI02597329'})
   RETURN z.ci_sm_id
   $$) as (ci_sm_id agtype);
   ```
   Total query runtime: 2 secs.
   
   
   ```
   SELECT * FROM cypher('graph', $$
   MATCH (z:type1)-[]->()-[]->()-[]->(b:type2 {ci_sm_id: 'CI02597329'})
   RETURN z.ci_sm_id
   $$) as (ci_sm_id agtype);
   ```
   Total query runtime: 50 secs.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@age.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org