maxdemarzi · December 8, 2021 10:49
diff --git a/__usage.adoc b/__usage.adoc
diff --git a/_perftest.sh b/_perftest.sh
 function run {
 	echo "{\"statements\":[{\"statement\":\"$1\"}]}" > perf_test.json
 	echo "Query: $1" >> perf_results.txt
 	ab -c ${3-4} -n ${2-10000} -p perf_test.json -T application/json -A neo4j:$4 -H accept:application/json http://127.0.0.1:7474/db/data/transaction/commit | tee -a perf_results.txt
 }
 CONCURRENCY=4
 REQUESTS=10000
 PWD=admin
 echo "Performance Test Northwind: concurrency $CONCURRENCY requests: $REQUESTS " > perf_results.txt
 run 'MATCH (c:Category {categoryName:'Produce'})<--(:Product)<--(s:Supplier) RETURN DISTINCT s.companyName as ProduceSuppliers' $REQUESTS $CONCURRENCY $PWD
 run 'MATCH (s:Supplier)-->(:Product)-->(c:Category) RETURN s.companyName as Company, collect(distinct c.categoryName) as Categories' $REQUESTS $CONCURRENCY $PWD
 run 'MATCH (cust:Customer)-[:PURCHASED]->(:Order)-[o:ORDERS]->(p:Product), (p)-[:PART_OF]->(c:Category {categoryName:"Produce"}) RETURN DISTINCT cust.contactName as CustomerName, SUM(o.quantity) AS TotalProductsPurchased' $REQUESTS $CONCURRENCY $PWD
diff --git a/_run_ab.sh b/_run_ab.sh
 # usage ./_run_ab.sh 4 10000 create_plain.json
 CONCURRENT=${1-10}
 REQUESTS=${2-10000}
 COMMAND=${3-postquery.json}
 PORT=${4-7474}
 ab $AB_OPTS -k -c $CONCURRENT -n $REQUESTS -p $COMMAND -T application/json -H accept:application/json http://127.0.0.1:${PORT}/db/data/transaction/commit 
diff --git a/create_1.json b/create_1.json
 {"statements":[{"statement":"CREATE (_0 {type:'Bike'}), (_0)-[:REL]->(_0)"}]}
diff --git a/create_100.json b/create_100.json
 {"statements":[{"statement":"FOREACH (r in range(1,100) | CREATE (_0 {type:'Bike'}), (_0)-[:REL]->(_0))"}]}
diff --git a/create_label.json b/create_label.json
 {"statements":[{"statement":"CREATE (_0:`Bike`),  (_1:`Wheel`), (_2:`Wheel`), (_0)-[:WHEELS]->(_1), (_0)-[:WHEELS]->(_2) RETURN id(_0) AS _0, id(_1) AS _1, id(_2) AS _2","parameters":{},"resultDataContents":["row"]}]}
diff --git a/create_plain.json b/create_plain.json
 {"statements":[{"statement":"CREATE (_0 {type:'Bike'}),  (_1 {type:'Wheel'}), (_2 {type:'Wheel'}), (_0)-[:WHEELS]->(_1), (_0)-[:WHEELS]->(_2) RETURN id(_0) AS _0, id(_1) AS _1, id(_2) AS _2","parameters":{},"resultDataContents":["row"]}]}
diff --git a/fof.json b/fof.json
 {"statements":[{"statement":"MATCH (me:User {username:'Kaylee83639'})-[:FRIENDS]-(people:User)-[:FRIENDS]-(fof:User) WHERE me <> fof and not(me)-[:FRIENDS]-(fof) return fof,count(*) as freq order by freq desc limit 10;"}]}
diff --git a/max.json b/max.json
 {"statements":[{"statement":"MATCH (me:User {username:'Kaylee83639'})-[:FRIENDS]-(people) RETURN people.username"}]}
diff --git a/simple_lookup.json b/simple_lookup.json
 {"statements":[{"statement":"MATCH (n) WHERE id(n) = 10 return id(n)"}]}
diff --git a/simple_lookup_property.json b/simple_lookup_property.json
 {"statements":[{"statement":"MATCH (n:Tag) WHERE n.tagId = 'neo4j' return n"}]}
	function run {
	echo "{\"statements\":[{\"statement\":\"$1\"}]}" > perf_test.json
	echo "Query: $1" >> perf_results.txt
	ab -c ${3-4} -n ${2-10000} -p perf_test.json -T application/json -A neo4j:$4 -H accept:application/json http://127.0.0.1:7474/db/data/transaction/commit \| tee -a perf_results.txt
	}
	CONCURRENCY=4
	REQUESTS=10000
	PWD=admin
	echo "Performance Test Northwind: concurrency $CONCURRENCY requests: $REQUESTS " > perf_results.txt
	run 'MATCH (c:Category {categoryName:'Produce'})<--(:Product)<--(s:Supplier) RETURN DISTINCT s.companyName as ProduceSuppliers' $REQUESTS $CONCURRENCY $PWD
	run 'MATCH (s:Supplier)-->(:Product)-->(c:Category) RETURN s.companyName as Company, collect(distinct c.categoryName) as Categories' $REQUESTS $CONCURRENCY $PWD
	run 'MATCH (cust:Customer)-[:PURCHASED]->(:Order)-[o:ORDERS]->(p:Product), (p)-[:PART_OF]->(c:Category {categoryName:"Produce"}) RETURN DISTINCT cust.contactName as CustomerName, SUM(o.quantity) AS TotalProductsPurchased' $REQUESTS $CONCURRENCY $PWD
	# usage ./_run_ab.sh 4 10000 create_plain.json
	CONCURRENT=${1-10}
	REQUESTS=${2-10000}
	COMMAND=${3-postquery.json}
	PORT=${4-7474}
	ab $AB_OPTS -k -c $CONCURRENT -n $REQUESTS -p $COMMAND -T application/json -H accept:application/json http://127.0.0.1:${PORT}/db/data/transaction/commit