Hi everyone, Lukas came to our company some weeks ago to demonstrate jOOQ and we had a look at the pagination query for oracle. Some months ago, I came along a very interesting paper showing different techniques for doing efficient pagination.
http://www.inf.unideb.hu/~gabora/pagination/results.html jOOQ would seem to use the solution n. 2. I have made a patch for n.3, but could not test it yet (trouble with sonatype m2e on indigo...) here it is. https://github.com/stanislas/jOOQ/commit/cea35b05390cd4ccebccf19621ecfafacf2da148 What do you think? Cheers, stan.
