The best way to handle this is a value list pattern (you may already be doing this). Use a stateless session bean to make a direct call to the database and get bare information about each record. When you mine down to an individual record, then fetch the entity bean corresponding to that record. -----Original Message----- From: Ananta s [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 10:20 AM To: [EMAIL PROTECTED] 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". This message is for the named person's use only. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal written confirmation. =========================================================================== 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".
