What is the meaning of max and offset pagination params in createcriteria?

Question

In the Grails documentation, we read:

def results = Book.list(max: 10, offset: 100)

• max - The maximum number to list
• offset - The offset from the first result to list from

Also, from this MySQL tutorial, we read: the offset specifies the offset of the first row to return.

Questions:

• Is max the maximium number of rows per page?
• Could you give me an example about the offset meaning?

Answer 1

Hello GORM, when you return me a list of Books give me only 10 (max) results but do not start from the Zeroth (offset = 0) place, instead start listing results from 100th (offset) result.