vladiksun commented on issue #1000:
URL: https://github.com/apache/age/issues/1000#issuecomment-1672522910
@jrgemignani thank you for taking a look. Indeed without creating a
functional index there is no way to check if that actuality might work.
If you were able to create such an index, one thing seems suspicious to me.
With an index the actual execution time is longer than without it. But this
probably depends on the setup.
For basic queries like searching the vertex by its property we decided not
to use Cypher calls, but instead usual SQL queries with functional indexes
around properties values. It is much faster and we can use native FTS this way.
I believe this is possible because agtype is a superset of a jsonb hence we can
use it like jsonb.
But for traversal queries the index should help reduce the filtering time of
incoming or outgoing vertices.
For example queries with scenarios - find all outgoing vertices with label
'A' from the start vertex label 'B' where some 'A''s property IN [value1,
value2]. I assume with more hops involved ('A's could be chained in a
hierarchy) such queries take longer without index on a specific property.
--
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-unsubscr...@age.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
