GraphScope icon indicating copy to clipboard operation
GraphScope copied to clipboard

refactor(interactive): Accelerate the Adhoc query compilation

Open zhanglei1949 opened this issue 1 year ago • 1 comments

When running Adhoc query on GraphScope Interactive, most time is spent on runtime code generation and compilation. Here is a rough test case on Movie graph:

Simple Query: MATCH(n) return COUNT(n); Complex Query: MATCH (tom:Person {name: 'Tom Hanks'})-[:ACTED_IN]->(:Movie)<-[:ACTED_IN]-(coActor:Person) WITH DISTINCT coActor.name AS coActorName ORDER BY coActorName ASC LIMIT 10 return coActorName;

  • Simple Query(gcc 9.4): 11.5
  • Complex Query(gcc 9.4) : 13.4
  • Simple Query(aocc 4.1): 14.6s
  • Complex Query(aocc 4.1) : 16.3s

All tested on x86_64 platform.

We need to speed up the adhoc query's compilation, even if it means sacrificing some of the execution efficiency of ad hoc queries.

zhanglei1949 avatar Feb 07 '24 01:02 zhanglei1949

/cc @zhanglei1949, this issus/pr has had no activity for for a long time, could you folks help to review the status ? If this issue/pr is waiting for further response from the reporter/author, please help to add the label requires-further-info to suppress further notification. If this issue/pr is not in your queue, please unassign yourself from it to avoid been notified again.

github-actions[bot] avatar Feb 27 '24 13:02 github-actions[bot]