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

Without exact details of the query (and the means of invoking it) it's not possible for me to be sure, but a suggestion might be to use the pseudo column rownum (if you resultset is ordered).

"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message news:<srEP7.1896$ER5.231004_at_rwcrnsc52>...
> 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 - 14:57:30 CET