What's better to retrieve complex data from ArangoDB: A big query with all collection joins and graph traversal or multiple queries for each piece of data?
ArangoDB, what's the better way to peform queries?
269 views Asked by Helder Santana At
1
There are 1 answers
Related Questions in ARANGODB
- ConcurrentModificationException happen for findAllById in arangodb-spring-data with concurrent workers
- How to exclude a weaved property from an entity in Spring Data?
- How to Pass-in a Collection name and Document Key to an AQL query to update the document
- Convert ArangoDB query to MongoDB query
- How can I connect to a local ArangoDB database from an Appsmith Javascript Object from Windows 10
- ArangoDB waits infinitely after issuing start command by arangodb
- ArangoDB AQL Upsert Operation Clears CreateDate on Update Instead of Only on Insert
- ArangoDB prompts to enter the root password despite the authentication is disabled in the command line
- In ArangoDB AQL is there anything like mysqli_real_escape_string?
- AQL query takes 30+ seconds
- ArangoDB and ldap
- Getting error "expecting POST /_api/cursor" from ArangoDB.js
- ArangoDb: Is it possible to determine the direction of the current path?
- Is it possible to insert only if query returns no results
- ArangoDB on K8S: thousands of Open FD filedescriptors
Related Questions in AQL
- How to Pass-in a Collection name and Document Key to an AQL query to update the document
- Is it allowable to use different AQL sampling plan/level for large lot size
- In ArangoDB AQL is there anything like mysqli_real_escape_string?
- AQL query takes 30+ seconds
- ArangoDb: Is it possible to determine the direction of the current path?
- Add count of group that does not exist for the row
- GEO_DISTANCE search in view returns nothing, even though ANALYZER returns true
- Confusion on `IN` and `==` in ANALYZER(), and fulltext search question
- Passing variable value in items.find query using python
- How to generate ArangoDB queries mechanically?
- How do you find documents that do not match across 2 collections in ArangoDB?
- Vertex centric index not used by Arango
- I am new to aragodb and currently exploring on graphs basically, So is there a multiple ways to create graphs in arango, Any help is appreciated
- Number of related users to projects in ArangoDB
- I need to implement a fuzzy string search with Spring + ArangoDB
Related Questions in ARANGODB-PHP
- In ArangoDB AQL is there anything like mysqli_real_escape_string?
- Problem ArangoDB connection with PHP vendor
- arangodb document key length best practice
- Sorting on _key and filter
- How to increase `maxTransactionSize` for Streaming Transactions in arangodb-php
- Mass Looped/Bulk Inserts using PHP into ArrangoDB
- AQL query with updatingdocuments from two collections runs as transaction or not?
- How to fetch all Vertices data from the ArangoDB Graph using REST api
- arangodb kill query not working require("org/arangodb/aql/queries").kill("2418")
- Can arangodb handle 20 billion records?
- How to execute arangodb transaction in php after redis transaction is comfirmed?
- Difficult with registering a document in arangodb-php
- Arangov2.8 - Examples of register user functions in AQL
- How can I list the users with the most similar entries with ArangoDB
- How to call ArangoDB Foxx applications from arangodb-php
Related Questions in NOSQL
- In Redis Databases how do we need to calculate the table size
- DynamoDB structure recommendation
- Efficiently read Firestore's document reference field contents
- Removing blocked users from the pipeline with lookup in mongodb
- Make a Cluster without using MongoDB Atlas
- MongoDB: Reading a large file vs uploading in a collection
- Mongo DB find objects (arrays) from Object
- Horizontal scaling strategy with 10,000 shards
- MongoDB aggregation - sum of array of nested objects
- how to configure mongodb to always cache 100% of a collection on RAM?
- Mongo Db global filter with C#
- TypeORM/MongoDB - sort collection
- Use Mongo $text search in limited set
- Not a value in projecting or not projecting MongoDB
- Which database management system should I use for this task?
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
I think it depends on several aspects, e.g. the operation(s) you want to perform, scenario in which the querie(s) should be executed or if you favor performance over maintainability.
AQL provides the ability to write a single non-trivial query which might span through entire dataset and perform complex operation(s). Dissolving a big query into multiple smaller ones might improve maintainability and code readability, but on the other hand separate queries for each piece of data might have negative performance impact in the form of network latency associated with each request. One should also consider if the scenario allows to work with partial results returned from database while the other batch of queries is being processed.