Documentation / SQL / OLAP
OLTP vs OLAP
Ebean ORM queries are good for typical OLTP query use cases but there are many queries that can be written in SQL that ORM is not well suited to in the reporting and OLAP area.
Ebean ORM queries are focused to OLTP. Don't forget about using SQL where appropriate.
For Ebean the focus is to use ORM queries for OLTP use cases. The plan is not to expand the ORM
query language to cover OLAP queries but to instead have good integration with SQL
via findNative
, RawSql
and SqlQuery
.