A while ago, I have blogged about how to perform keyset pagination (some also call this the "seek method"). Keyset pagination is a very powerful technique to perform constant-time pagination also on very large result sets, where "classic" OFFSET pagination will inevitably get slow on large page numbers. Keyset pagination is most useful for lazy … Continue reading Faster SQL Pagination with Keysets, Continued
Tag: Keyset paging
jOOQ Newsletter October 28, 2013
subscribe to the newsletter here jOOQ 3.2 Licensing Update Three weeks ago, we have announced and released jOOQ 3.2 under the terms of a new dual-licensing model offering jOOQ's support for commercial databases under a commercial jOOQ license. The jOOQ community has reacted intensively on the user group, most of the feedback having been very positive. The licensing … Continue reading jOOQ Newsletter October 28, 2013