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
-
Streaming result set (1 messages)
- Posted by: Ravindra Gupta
- Posted on: May 13 2004 17:14 EDT
Threaded Messages (1)
- Streaming result set by Sanjaya Ganesh on May 13 2004 23:47 EDT
-
Streaming result set[ Go to top ]
- Posted by: Sanjaya Ganesh
- Posted on: May 13 2004 23:47 EDT
- in response to Ravindra Gupta
(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.
-Sanjay