Re: Limit the record number when retrieving data from database.
From: Thomas Kellerer <no_address_at_gmx.net>
Date: Thu, 06 Dec 2001 09:36:55 +0100
Message-ID: <3C0F2E27.5040201_at_gmx.net>
Date: Thu, 06 Dec 2001 09:36:55 +0100
Message-ID: <3C0F2E27.5040201_at_gmx.net>
Jason wrote:
> 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
>
>
>
Doesn't Statement.setMaxRows() work for you???
Thomas Received on Thu Dec 06 2001 - 09:36:55 CET