search

digicatapult / fornax

Approximate fuzzy subgraph matching in polynomial time
Apache License 2.0
21 stars 4 forks source link

Slow SQL query #11

Closed Dan-Staff closed 5 years ago

Dan-Staff commented 5 years ago

According to the logs the following query is very slow:

SELECT 
    node.node_id AS node_node_id, 
    node.graph_id AS node_graph_id, 
    node.meta AS node_meta 
FROM node 
JOIN "query" 
ON node.graph_id = "query".end_graph_id 
JOIN "match" 
ON node.node_id = "match"."end" 
WHERE "query".query_id = ? ORDER BY node.node_id ASC
Dan-Staff commented 5 years ago

See #16