Re: Limit the record number when retrieving data from database.

I don't know how you are retrieving your result set. If you are using some method that does not allow a row by row retrieval then switch to one that does.
Jim
"Jason" <jiesong-zhu_at_home.com> wrote in message news:OFCP7.287334$5A3.111910296_at_news1.rdc2.pa.home.com...
> Could you give me some more detailed suggestions such as how I could
 control
> the record number at one data retrieve? Should I add that control in the
> SQL query or from the Java Applet side, and how? Thanks again!
>
> "Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message
> news:7uCP7.1074$w85.150837_at_rwcrnsc54...
> > Just retrieve the number of records you want. When you want more fetch
> > more.
> > Jim
> > "Jason" <jiesong-zhu_at_home.com> wrote in message
> > news:igvP7.286485$5A3.111472391_at_news1.rdc2.pa.home.com...
> > > I am working on the Java interface talking with an Oracle8i database.
 As
> > > the total records are more than 7,000, it makes the Applet very slow.
 Since
> > > initially, only about 100 records are enough for the Applet to run, I
 am
> > > thinking to retrieve those 7,000 records from database not at once,
 but
 in
> > > several batches so that the Applet can start running very quickly.
> > > Well, is there a way to do that, either by sql query or from the
 Applet?
> > >
> > > Thanks! -- Jason
> > >
> > >
> > >
> >
> >
>
>
Received on Thu Dec 06 2001 - 07:42:32 CET