hi ananta
Why don't you use JDBC's setFetchSize() method for limiting your fetching?
setFetchSize(int rows)
Gives the JDBC driver a hint as to the number of rows that should
be fetched from the database when more rows are needed for this ResultSet
object.
Thanks and Regards
Saminathan.
----- Original Message -----
From: "Ananta s" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 27, 2002 8:50 PM
Subject: fetching large number of records from the db
> Hi,
>
> I have a very basic question:
>
> We are developing a admin interface for our application. In which we need
to
> fetch all the user records based on some condition. There is a possiblity
> that on a particular condition the number of record fetched could be
100000.
> We are using a stateless bean and a entity bean for this task. I am not
sure
> whether the beans will be able to handle so many records at same time. Any
> suggestion pls?
>
> Also I want to send 1000 records at a time to the browser and fetch the
next
> 1000 in the next call. How to achive this?
>
> Ananta
>
>
===========================================================================
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff EJB-INTEREST". For general help, send email to
> [EMAIL PROTECTED] and include in the body of the message "help".
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
