Re: Benchmarking result

2021-09-13 Thread John Gemignani
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

Re: combining multiple cypher queries into one query

2021-09-13 Thread Josh Innis
I should have reread my response twice, lol. I rewrote the last sentence to make sense. Yes, without a RETURN clause the function we are trying to benchmark will not be called, and naming all the variables in a CREATE clause with a significant amount of vertices created to measure performance

Re: combining multiple cypher queries into one query

2021-09-13 Thread Josh Innis
Hi Viet, Yes, without a RETURN clause the function we are trying to benchmark will not be called, and naming all the variables in a CREATE clause with a significant amount of vertices created to measure performance would not be the most accurate test to how cypher would be used for most people.

Re: Benchmarking result

2021-09-13 Thread Josh Innis
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

[DISCUSS] Official Docker Image for Apache AGE

2021-09-13 Thread Joe Fagan
Dear Community, @Mentors please advise on how to make this AGE docker image official and hosted on the Apache Docker Hub. https://hub.docker.com/repository/docker/joefagan/incubator-age Thanks Joe

Docker image updated to version 0.6.0

2021-09-13 Thread Joe Fagan
I've pushed a docker image to my private repository, built from Postgres 11 with the Apache AGE extension 0.6.0 added, and some instructions in the readme. https://hub.docker.com/repository/docker/joefagan/incubator-age To confirm the extension version run. postgres=# select extname, extversion

Re: Benchmarking result

2021-09-13 Thread Joe Fagan
[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

combining multiple cypher queries into one query

2021-09-13 Thread VUONG QUOC Viet
Hi guys, I've followed John's suggestion on Friday, which was to combined multiple cypher queries into 1 long query, like this: SELECT * FROM cypher('test_graph', $$ CREATE(:Person{id: 123, name: 'Andres', title: 'Developer', city: 'Seattle'}) CREATE(:Person{id: 123, name: 'Brian', title:

Re: [DISCUSS] Apache AGE 0.6.0 Release

2021-09-13 Thread Eya Badal
+1, looking forward to this release!!! On 2021/09/10 16:52:03, Josh Innis wrote: > Dear Apache Community, > > > > We would like to discuss the Apache AGE release 0.6.0. that we have been > working toward it. > > > > To learn more about Apache AGE, please see http://age.apache.org/ > >

New Committer: Alex Kwak

2021-09-13 Thread Eya Badal
Dear Apache community, The Project Management Committee (PMC) for Apache AGE (Incubating) has invited Alex Kwak to become a committer and we are pleased to announce that he has accepted. Being a committer enables easier contribution to the project. This should enable better productivity. A PMC

[GitHub] [incubator-age] pdpotter commented on issue #113: How to work with dynamic property

2021-09-13 Thread GitBox
pdpotter commented on issue #113: URL: https://github.com/apache/incubator-age/issues/113#issuecomment-918093763 Example for the second solution: Create person nodes ``` SELECT * FROM ag_catalog.cypher( 'people', $$ CREATE (a:Person {data:{name:'Jane', 'age':

[GitHub] [incubator-age] nieyankai removed a comment on issue #113: How to work with dynamic property

2021-09-13 Thread GitBox
nieyankai removed a comment on issue #113: URL: https://github.com/apache/incubator-age/issues/113#issuecomment-918046199 You got it. The property is not predefined, no one knows the property key util the user enter it. So the 2nd solution is a choice, but this will encounter another

[GitHub] [incubator-age] nieyankai commented on issue #113: How to work with dynamic property

2021-09-13 Thread GitBox
nieyankai commented on issue #113: URL: https://github.com/apache/incubator-age/issues/113#issuecomment-918047683 > I understood the question as "How can I attach properties and values to a vertex if I don't know the properties beforehand". Are the properties predefined (e.g., the user

[GitHub] [incubator-age] nieyankai removed a comment on issue #113: How to work with dynamic property

2021-09-13 Thread GitBox
nieyankai removed a comment on issue #113: URL: https://github.com/apache/incubator-age/issues/113#issuecomment-918047154 > I understood the question as "How can I attach properties and values to a vertex if I don't know the properties beforehand". Are the properties predefined (e.g., the

[GitHub] [incubator-age] nieyankai commented on issue #113: How to work with dynamic property

2021-09-13 Thread GitBox
nieyankai commented on issue #113: URL: https://github.com/apache/incubator-age/issues/113#issuecomment-918047154 > I understood the question as "How can I attach properties and values to a vertex if I don't know the properties beforehand". Are the properties predefined (e.g., the user

[GitHub] [incubator-age] nieyankai commented on issue #113: How to work with dynamic property

2021-09-13 Thread GitBox
nieyankai commented on issue #113: URL: https://github.com/apache/incubator-age/issues/113#issuecomment-918046199 You got it. The property is not predefined, no one knows the property key util the user enter it. So the 2nd solution is a choice, but this will encounter another problem: