Graph & Beyond Lunch Break #5: AQL Query Performance Optimization 101 (Part I) - ArangoDB

Sign up for ArangoGraph Insights Platform

Before signing up, please accept our terms & conditions and privacy policy.

What to expect after you signup
You can try out ArangoDB Cloud FREE for 14 days. No credit card required and you are not obligated to keep using ArangoDB Cloud.

At the end of your free trial, enter your credit card details to continue using ArangoDB Cloud.

If you decide that ArangoDB Cloud is not (yet) for you, you can simply leave and come back later.

ACCEPT

Graph & Beyond Lunch Break #5: AQL Query Performance Optimization 101 (Part I)

Graph & Beyond Lunch Break #5: AQL Query Performance Optimization 101 (Part I)

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 will cover the basics of AQL query performance optimization. He will demonstrate if and how your indexes in ArangoDB can help AQL query performance, as well as share 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.

In this session we’ll focus on single-server query performance. Although all the techniques shown here can be used in cluster setups as well, there will be a follow-up session dedicated to cluster query performance.

You can find Part II 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.

Register now to watch the recording:

Jan Steemann

Jan Steemann