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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
