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

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 - 05:41:18 CET