Good explanation Josh.
I will add a two comments about the results -
1. The changes made to the code for this specific improvement were known
to be small. However, the changes will still decrease the execution time
overall due to less code needing to be executed.
2. The VLE code inclu
Runtime performance of any query in SQL is dictated by the execution tree
structure. AGE translates cypher commands into SQL as much as possible.
Some exceptions are: variable length edges, the merge clause, and the
CREATE/REMOVE/SET/DELETE clauses. (Sidenote: we do try to use Postgres
functionalit
[image: image.png]
Viet,
For the results of last week's test unfortunately the optimised code is not
statistically significantly different from the non-optimised.
When you send the new test results I can run it again (should take only a
few minutes now I have it set up) and re-run the test. I ca
Great Josh.
I learnt loads reading your script
On Fri, 10 Sep 2021 at 18:14, Josh Innis wrote:
> Good Job Viet. I made some modifications to the SQL function that you
> made. This may be a way to analyze how long it takes to run the queries in
> a purely postgres way that only calls explain anal
Good Job Viet. I made some modifications to the SQL function that you made.
This may be a way to analyze how long it takes to run the queries in a
purely postgres way that only calls explain analyze once.
SET search_path TO ag_catalog;
LOAD 'age';
SELECT create_graph('test_graph');
CREATE OR REPL
Good job!
On Thu, Sep 9, 2021 at 9:11 PM VUONG QUOC Viet wrote:
> Hi Joe and Muhammad,
>
> I've finished the benchmarking experiments after listening to Muhammad's
> suggestions to improve the process: 1. to create 2 separate repos for
> original code and optimized code and 2. place the create_g
Hi Joe and Muhammad,
I've finished the benchmarking experiments after listening to Muhammad's
suggestions to improve the process: 1. to create 2 separate repos for
original code and optimized code and 2. place the create_graph at the
beginning and drop_graph at the end of each sql file.
The exper