Kobaruon commented on issue #1974:
URL: https://github.com/apache/age/issues/1974#issuecomment-2222202727
@jrgemignani it takes around 3 minutes to run, we expect around 1 second
execution time. DB vm has 8 cores 32GB memory, but the data size is small
~600mb.
We have a very similar query, same table structure and same indexes. On that
table, query below runs under 1 second.
```
SELECT * from cypher('passv2', $$
MATCH (V)-[R:TCP]-(V2)
RETURN V,R,V2 LIMIT 100
$$) as (V agtype, R agtype, V2 agtype);
```
I mean yes without LIMIT it takes ages to run, but with LIMIT we expect fast
execution.
Edge label counts don't know if that matters.
--
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]
