Exam Certified Platform Developer II topic 1 question 123 discussion

OFFSET is applied to the result set returned at the time of the query. No server-side cursor is created to cache the full result set for future OFFSET queries. The page results may change if the underlying data is modified during multiple queries using OFFSET into the same result set. As an example, suppose that the following query normally returns a full result set of 50 rows, and the first 10 rows are skipped using an OFFSET clause:

b

Standard set controller with caching logic implemented

Pros · Manages data sets on the server, which reduces page state and increases performance · Allows you to paginate over large data sets that have up to 10,000 records · Includes built-in functionality such as next, previous, first, last, getResultSize, and other methods that can simplify your page · Allows you to paginate forward and backward or to any page within the result set · Uses a server-side cursor to cache the entire result set, so results will not change if data changes in the database while a user is paginating from one page to the next Cons · Has built-in functionality that results in a very small increase in view state size · Can be used only in Apex