Web tier: servlets, JSP, Web frameworks: Streaming result set
My Application is fairly simple .
I have an applet which calls the data layer to bring the data and display .
Since data is huge ( 10000-20000 records ) , first call from my report applet is very slow .
I wanted to use Streaming result set or any design patten
which can bring data for my first page initially and while displaying data on my first page , the backend thread can bring rest of the data , for display .
Any example ?? sample code
(1) Look at the thread on RemoteIterator in this site. You can implement the same in Oracle queries as well keepin page counters yourself.
(2) JDBC has APIs that can limit results. If you are using rowsets, disconnected rowsets also allow this feature.