Skip to content

Instantly share code, notes, and snippets.

{
"$schema": "https://json-schema.org/draft-07/schema#",
"type": "object",
"properties": {
"projects": {
"description": "Projects to manage enrolment of",
"type": "object",
"patternProperties": {
"^[a-z0-9]([-a-z0-9]*[a-z0-9]){0,62}$": {
"type": "object",
@djmcgreal-cc
djmcgreal-cc / 1001-sub-loops-explain-3-4-7.txt
Created August 28, 2019 12:52
Explained 1001 sub-loops AQL
Query String (truncated):
let let_1000 = (FOR element in 1000..2000 filter element == 1000 return element)
let let_1001 = (FOR element in 1000..2000 filter element == 1001 return element)
let let_1002 = (FOR element in 1000..2000 filter element == 1002 return element)
let let_1003 = (FOR element in 1000..2000 filter element == 1003 return element)
let let_1004 = (FOR element in 1000..2000 filter element == 1004 return element)
let let_1005 = (FOR element in 1000..2000 filter element == 1005 return element)
let let_1006 = (FOR element in 1000..2000 filter element == 1006 return element)
let let_1007 = (FOR element in 1000..2000 filter element == 1007 return element)
let let_1008 = (FOR element in 1000..2000 filter element == 1008 return element)
@djmcgreal-cc
djmcgreal-cc / 1001-sub-loops-explain-3-5-0.txt
Last active August 28, 2019 12:52
Output of explain for 1001 sub loop AQL query
Query String (truncated):
let let_1000 = (FOR element in 1000..2000 filter element == 1000 return element)
let let_1001 = (FOR element in 1000..2000 filter element == 1001 return element)
let let_1002 = (FOR element in 1000..2000 filter element == 1002 return element)
let let_1003 = (FOR element in 1000..2000 filter element == 1003 return element)
let let_1004 = (FOR element in 1000..2000 filter element == 1004 return element)
let let_1005 = (FOR element in 1000..2000 filter element == 1005 return element)
let let_1006 = (FOR element in 1000..2000 filter element == 1006 return element)
let let_1007 = (FOR element in 1000..2000 filter element == 1007 return element)
let let_1008 = (FOR element in 1000..2000 filter element == 1008 return element)
@djmcgreal-cc
djmcgreal-cc / 1001-sub-loops.aql
Created August 28, 2019 12:37
Excessive memory consumption when there are many sub loops
let let_1000 = (FOR element in 1000..2000 filter element == 1000 return element)
let let_1001 = (FOR element in 1000..2000 filter element == 1001 return element)
let let_1002 = (FOR element in 1000..2000 filter element == 1002 return element)
let let_1003 = (FOR element in 1000..2000 filter element == 1003 return element)
let let_1004 = (FOR element in 1000..2000 filter element == 1004 return element)
let let_1005 = (FOR element in 1000..2000 filter element == 1005 return element)
let let_1006 = (FOR element in 1000..2000 filter element == 1006 return element)
let let_1007 = (FOR element in 1000..2000 filter element == 1007 return element)
let let_1008 = (FOR element in 1000..2000 filter element == 1008 return element)
let let_1009 = (FOR element in 1000..2000 filter element == 1009 return element)