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?
267 Views Asked by Helder Santana At
1
There are 1 best solutions below
Related Questions in ARANGODB
- ArangoDb get latest document from all collections
- ArangoDB graph operations via REST API
- Opening Foxx API to local network
- How do I access inserted document's _id within a transaction in ArangoDB
- How to approximate execution time of ArangoDB count function
- How to read data from collection in an ArangoDB Foxx app?
- ArangoDB document database and also a graph database? How is it possible?
- Validating array items with joi in a Foxx app
- GRAPH_TRAVERSAL result enclosed in (Array of) Array of Array in Arangodb
- number of 'graphs' in a ArangoDB database
- In Python, how do I create an edge collection and document for an arangodb?
- Arangodb import via http api using node.js
- Is ArangoDB edge document right place to put additional key-value?
- How to call external function in background tasks in arangodb
- ArangoDB create Vertex REST API without knowing the vertex id's
Related Questions in AQL
- ArangoDb get latest document from all collections
- ArangoDB graph operations via REST API
- How to approximate execution time of ArangoDB count function
- Is there a way to use dynamic collection names in AQL?
- Is it possible to create edges and vertexes simultaneously in ArangoDB
- Is there a way to create projection without explicit listing of document properties?
- Arangodb Aql SORT not work for edge iteration
- Aerospike AQL Query Against List of Values
- Sort direct neighbor nodes (books) by attribute of 2nd degree neighbors (authors) for user book list?
- AQL - graph traversal - filtering on path with complex condition
- make tree data structure from query in Arangodb
- Arango DB performace: edge vs. DOCUMENT()
- Can graph db solve my graph problems?
- AQL Path from Node to Leaf
- Value of stats.FullCount is wrong when AQL IN operator is used
Related Questions in ARANGODB-PHP
- Can arangodb handle 20 billion records?
- How to get filtered result by using Hash Index in ArangoDB?
- Traverse up in ArangoDB
- How to Compare Two Similar Graphs in ArangoDB that the result would yield the difference in Paths and Vertices?
- How to execute arangodb transaction in php after redis transaction is comfirmed?
- Difficult with registering a document in arangodb-php
- arangodb kill query not working require("org/arangodb/aql/queries").kill("2418")
- How i can receive next or previous element in arango collection?
- How to do user registration and authentication in PHP with ArangoDB?
- How to traverse a graph with ArangoDB and PHP
- arangodb document key length best practice
- How can I list the users with the most similar entries with ArangoDB
- AQL query with updatingdocuments from two collections runs as transaction or not?
- ArangoDB, what's the better way to peform queries?
- Sorting on _key and filter
Related Questions in NOSQL
- Developing a search and tag heavy website
- PostgreSQL 9.4 - Elements of jsonb array to ts_vector in
- ArangoDb get latest document from all collections
- Modeling with MongoDB and Mongoose
- Any high-level .NET clients for PostgreSQL's JSON type?
- Filtered Query in Elastic Search
- Nosql database design for complex querying
- JDBC or JPA for NoSQL
- How to connect Clusterpoint database to an android appliaction
- How to write query to my Cloudant database?
- How do I query X specific documents all at once using an index with pouchdb?
- Project a _id ref field as document
- MongoDB from PHP strange behavior
- MongoDB slow log (profiler) shows many many "killcursors" action when heavy load comes, why? and what killcursors do?
- Optimize duplicate values in NoSql key-value storage
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)
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?
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.