Index Speedups in ArangoDB 2.8: Enhancements

The upcoming 2.8 version of ArangoDB will provide several improvements in the area of index usage and query optimization. First of all, hash and skiplist indexes can now index individual array values. A dedicated post on this will follow shortly. Second, the query optimizer can make use multiple indexes per collection for queries with OR-combined…

Read More...

Foxx Module Resolution Changes in ArangoDB 2.8

The implementation of the JavaScript require function will be adjusted to improve compatibility with npm modules. The current implementation in 2.7 and earlier versions of ArangoDB strictly adheres to the CommonJS module standard, which deviates from the behaviour implemented in Node and browser bundlers. Module paths will now be resolved in the following ways:

Read More...

Enhanced Deadlock Detection: Improving ArangoDB Performance

The upcoming ArangoDB version 2.8 (currently in devel) will provide a much better deadlock detection mechanism than its predecessors. The new deadlock detection mechanism will kick in automatically when it detects operations that are mutually waiting for each other. In case it finds such deadlock, it will abort one of the operations so that the…

Read More...

Using Bind Parameters in the AQL Editor: ArangoDB

The AQL editor in the web interface is useful for running ad hoc AQL queries and trying things out. It provides a feature to explain the query and inspect its execution plan. This can be used to check if the query uses indexes, and which. So far the AQL editor only supported using query string…

Read More...

ArangoDB 2.7.1: Latest Enhancements & Fixes

In the first maintenance release of ArangoDB 2.7 we have switched from readline to linenoise ng for line-editing and history capabilities on the command line. Furthermore, the AQL function MERGE() improved, now working on a single array parameter, too. This allows combining the attributes of multiple objects from an array into a single object, e.g.:

Read More...

Benchmark: PostgreSQL, MongoDB, Neo4j, OrientDB and ArangoDB

The latest edition of the NoSQL Performance Benchmark (2018) has been released. In this blog post – which is a roundup of the performance blog series – I want to complete the picture of our NoSQL performance test and include some of the supportive feedback from the community. First of all, thanks for all your…

Read More...

ArangoDB 2.7 GA: Significant Improvements

Long awaited and now we´ve finished it! New major release of ArangoDB 2.7 is ready for download. First of all a big thanks to our community for your great support! We´ve implemented a lot of your ideas! After your feedback to RC1 and RC2 we are happy to bring a new major release to the…

Read More...

ArangoDB 2.6.9: Maintenance Release Highlights

In ArangoDB 2.6.9 we have fixed an AQL skiplist issue that occurs in a combination of sort and limit. When using a Skiplist index on an attribute (say “a”) and then using sort and skip on this attribute caused the result to be empty e.g.: require(“internal”).db.test.ensureSkiplist(“a”); require(“internal”).db._query(“FOR x IN test SORT x.a LIMIT 10, 10”);…

Read More...

ArangoDB 2.7 RC1: Preview the Latest Features

We put a lot of brainpower into the next major release of our favorite database. Thanks to your feedback and contributions we got some important steps forward. Share your professional experiences, opinions and feedback with us on this release candidate of ArangoDB 2.7. This is a quick info about the upcoming 2.7 release – for…

Read More...

ArangoDB Weekly 34: Updates, Tips, and Community Highlights

In just a few days we will publish our release candidate of ArangoDB 2.7. As secure performance and ease of use are our key goals, we worked hard on some nice improvements like Index Buckets (Reducing loading time for collections and enable faster resizing) Throughput Enhancements (Real world tests showed 25-75% increase of throughput compared…

Read More...