Prev Next

API / Apache Grails Interview questions

How can you optimize GORM queries to avoid the N+1 problem?

  1. Use eager fetching with join queries for associations you already know you'll need — a criteria query or HQL with an explicit join fetch retrieves the parent and its related records in a single database round trip instead of one query per parent, plus one more per child collection.
  2. Set the fetch strategy on the domain class mapping itself for associations that are almost always needed together, so every query against that class benefits without repeating the join logic at every call site.
  3. Use projections to retrieve only the specific columns actually needed, rather than hydrating full domain objects (and their lazy associations) when only a couple of fields are actually used.
  4. Batch-fetch collections using GORM's batch size configuration, which groups the "N" follow-up queries for related collections into fewer, larger queries instead of one query per parent row.
  5. Profile actual query counts during development (Grails supports SQL logging) rather than guessing, since the N+1 problem is easy to introduce accidentally through an innocent-looking loop over a lazy association and easy to miss without actually looking at the generated SQL.

The underlying discipline is deciding upfront, per query, whether related data is actually needed — and if so, fetching it in the same round trip rather than letting GORM's default lazy-loading trigger a fresh query every time a loop touches an association.

What database access pattern does the N+1 problem describe?
What is one concrete way to avoid the N+1 problem for an association you already know you'll need?

More Related questions...

What is Apache Grails? What is GORM? What is a Grails domain class? What is a Grails controller? What is a Groovy Server Page (GSP)? What is convention-over-configuration in Grails? What is a dynamic finder in GORM? What is Grails Forge? What is the Grails Wrapper (grailsw)? What is a Grails service? What are the types of environments Grails supports? What is scaffolding in Grails? What is a Grails plugin? Define GORM Data Services? How do you create a new Grails application using Grails Forge? Why did Grails move under the Apache Software Foundation? Why do we use GORM instead of writing raw SQL/JDBC? How does Grails apply convention-over-configuration to map URLs to controllers? What is the difference between Grails 7 and Grails 8? When should you use GORM Data Services instead of dynamic finders? What is the difference between a dynamic finder and a criteria query? What happens when a domain class fails validation in Grails? What is the difference between a Grails controller and a Grails service? Which is better for a new project in 2026: Grails 7 or Grails 8, and why? How can you optimize GORM queries to avoid the N+1 problem? How do you troubleshoot a LazyInitializationException in a Grails application? Explain the lifecycle of a request in a Grails application? Explain the execution flow of a GORM save() call under the hood? Explain the internal working of GORM Data Services? What is the difference between an interceptor and a filter in Grails? Why should you mark long-running database work with @Transactional at the service layer? What is a Grails command object? How does Grails integrate with Spring Security? What is the difference between static and dynamic scaffolding in Grails? How does Grails support internationalization (i18n)? Explain the internal working of Grails' convention-based URL mapping? What is the difference between Grails profiles like "web" and "rest-api"? How do you enforce validation constraints on a Grails domain class? What is the role of the asset-pipeline plugin in Grails? How does Grails support database migrations? Explain the sequence of events when a GSP page is rendered? What is the difference between GORM criteria queries and HQL? How do you configure multi-tenancy in a Grails application with GORM? What is the difference between Grails' component model and Spring Boot's plain REST controller approach? Explain how Grails' dependency injection works with Spring beans? How do you write unit and integration tests for a Grails application? What is the difference between unit tests and integration tests in Grails testing? Explain the internal working of a GORM dynamic finder at runtime? What is the difference between Apache Grails and Ruby on Rails? Explain how GORM's optimistic locking prevents concurrent update conflicts?
Show more question and Answers...


Comments & Discussions