AQL query for joining collections if not null and merging in single output
I have a graph with the following structure
ArangoDB query returns only 1000 documents
My Arangodb database has a collection with about 300.000 documents.
I want to import a list from all the documents containing a number and a key.
ArangoDB query returns only 1000 documents
My Arangodb database has a collection with about 300.000 documents.
I want to import a list from all the documents containing a number and a key.
ArangoDB query gives only 1000 collectios
My Arangodb database has a collection with about 300.000 documents.
I want to import a list from all the documents containing a number and a key.
.
AQL query to filter for 2 nested values
I have a document with some translations. I want to fetch two languages, from one query, instead of having to run it twice.
The reason for two is that English is the default, and will be used if the other selected language does not have a translation.
Is there a way of optimising following query for better edge case respose times?
Problem specification: I have been working on pretty large dataset of friends_with graph (3.5m users, 234m friend_with edges). User collection consist of: _key,_id,name friend_with edge collection: _key,_id,_from,_to (collection is denormalized, eg. 1->2 means also 2->1) I’m running arangoDB community on VM (32vcores, 32GB RAM, 400GB ssd). I need to effectively return list of friends of […]
Is there a way of optimising following query for better edge respose times?
Problem specification: I have been working on pretty large dataset of friends_with graph (3.5m users, 234m friend_with edges). User collection consist of: _key,_id,name friend_with edge collection: _key,_id,_from,_to (collection is denormalized, eg. 1->2 means also 2->1) I’m running arangoDB community on VM (32vcores, 32GB RAM, 400GB ssd). I need to effectively return list of friends of […]
AQL query RETURN type when retrieving data from a collection
I have a collection of financial transactions where each transaction has a payer and a receiver. Suppose I want to compute an aggregate (for example, max) amount of operations between all pairs of payers and receivers.