[GitHub] [age] jrgemignani commented on issue #628: Simple (a) -> (b) query taking up tens of minutes

["jrgemignani (via GitHub)" <gi...@apache.org>]

jrgemignani commented on issue #628:
URL: https://github.com/apache/age/issues/628#issuecomment-1405781446

   > @jrgemignani wow, it helped a lot! Went down from 10 minutes to 400 ms :) However, I'm confused... aren't my and your query equivalent?
   > 
   The queries are essentially the same, but the regular MATCH uses nested JOINS to **find** the results whereas the VLE MATCH uses a graph pathing function. It is a different engine that is **finding** the matches in each case.
   
   The reason the analyze outputs look similar is due to the VLE producing **candidates** that need to be **filtered** out.
   
   The problem with the regular MATCH is that these JOINS can nest way to deep, depending on the graph. This is compounded by the labels being in separate tables.
   
   


-- 
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: commits-unsubscribe@age.apache.org

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