Query by Slice, Parallel Execute, and Join: A Thread Pool Pattern in Java | Java.net

Query by Slice, Parallel Execute, and Join: A Thread Pool Pattern in Java | Java.net

Forums Blogs Projects People January 31, 2008 sets in small chunks with forward and backward navigability. Pagination can be done with custom code or with "http://en.wikipedia.org/wiki/Commercial_off-the-shelf">commercial, off-the-shelf (COTS) libraries. Nevertheless, many of these frameworks first bring the full dataset to the business, presentation, or client tier and then page them into small batches. This may not be the best possible solution; for one thing, such approaches consume huge amounts of memory. This article will first show you how to effectively utilize ROWNUM implement "true pagination": querying data in slices. Of course, you may also want to do some business processing to the fetched data. If you have millions of rows to be processed, you may want to process them in parallel to fully utilize the available processing power. In Java we use threads to do this, but with the advent of Java SE 5's , we also have a means to reuse the threads created.

Read full article from Query by Slice, Parallel Execute, and Join: A Thread Pool Pattern in Java | Java.net