This is Part 1 in a two-part series covering the basics of AQL query performance optimization.
In this lunch break, ArangoDB Senior Developer Jan Steemann covers the basics of AQL query performance optimization. He demonstrates if and how your indexes in ArangoDB can help AQL query performance, as well as shares practical advice around how to set them up so that they can help as much as possible. For this, we’ll look at the explain and profiling outputs of some AQL queries, and try to improve them until they are optimal.
You can find Part 2 of this lunch break, which covers AQL query performance optimizations for cluster setups, here.
About the Presenter:
After more than 30 years of playing around with 8-bit computers, assembler and scripting languages, Jan decided to move on to work in database engineering. Jan is now a senior C/C++ developer with the ArangoDB core team, being there from version 0.1. He is mostly working on performance optimization, storage engines and the querying functionality.