Overview

An overview of ORM queries in general and when you might look to use SQL queries.

N + 1

What is "N+1" and how queries can be optimised to minimise performance issues related to this.

Partial Objects

What are partial object queries and why are they important.

Automatic Tuning

Get Ebean to profile the application object graph use and automatically optimise the queries.

Type safe queries (Query beans)

We can generate "Query Beans" which provide the ability to write type safe queries.

// Example using Customer query bean
List<Customer> customers =
  new QCustomer()
      .name.startsWith("Rob")
      .status.equalTo(Customer.Status.NEW)
      .findList();

Query Features

The various query features such as paging, large queries, asynchronous queries, RawSql, SqlQuery etc.