Hi Just as some support to this topic.
Recently we're re-did our whole architecture to match the below mentioned model. Only if we are dealing with single 'things' (I hate to say entities as that is a technology term) do we implemenent our CMP/BMP model. For anyting requiring a list of read only objects we make use of Value Objects being returned by our List manager through a SLSB [jdbc direct to the db]. After about a year of development we noticed MAJOR performance loss to using a "findbyAll' style Entity call. Even when we set methods to be read only there was still 'issues' as to response time. We now removed the concept of 'findAllByXYZ' from all our entities and use List managers in a SLSB. As a note: we are using Websphere on the AS/400 so we're stuck with EJB 1.1. Rumour has it the performance has been improved in EJB 2.0 but I have yet had the time to check it all out. Understand we did these changes all in the name of performance as our application is pretty intense. -----Message d'origine----- De : A mailing list for Enterprise JavaBeans development [mailto:[EMAIL PROTECTED]]De la part de Peele, Dana Envoy� : Wednesday, February 27, 2002 10:59 AM � : [EMAIL PROTECTED] Objet : Re: fetching large number of records from the db 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". =========================================================================== 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".
