I was using read-ahead, as it's on by default. See original posting. -----Original Message----- From: Emerson Cargnin - SICREDI Serviços [mailto:emersonc@;sicredi.com.br] Sent: Tuesday, October 29, 2002 1:35 PM To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] Entity Bean Performance Tuning Help
i think that maybe using a read-ahead configuration for cmr could turn CMP usable, hence the cause of the slowness (IMHO) is the great number of selects as you navigate through each BEAN. Jason Westra wrote: > Dain wrote: > >>>I disagree with you here. It depends on the type of reads you are >>>doing. A lot of applications increase performance by offloading >>>processing to the database with very complex queries and stored >>>procedures, and the current CMP design can not benefit from this design. >> > This was my point. Sounds like you agree. :) The current CMP design has > problems with large, complex reads. You can't effectivly use CMP for > everything, nor was the EJB spec's CMP section able solve ALL data query > problems. > > J > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:jboss-user-admin@;lists.sourceforge.net]On Behalf Of Dain > Sundstrom > Sent: Tuesday, October 29, 2002 11:43 AM > To: [EMAIL PROTECTED] > Subject: Re: [JBoss-user] Entity Bean Performance Tuning Help > > > Jason Westra wrote: > >>Hi JBoss friends, >> >>I tend to agree with Bill and Dain's last posting here. There are certain >>things that CMP is not designed to do *well* and large, heavy reads is one >>of them. > > > I disagree with you here. It depends on the type of reads you are > doing. A lot of applications increase performance by offloading > processing to the database with very complex queries and stored > procedures, and the current CMP design can not benefit from this design. > The JBoss 4.0 design will be able to benefit from hand tuned queries. > > >>I'd venture to guess the same performance problem will occur on other app >>servers, in which case, it is not a war of servers, but a principle of >>application design (SSB+JDBC vs. CMP). If the numbers come in much better >>from testing on other app servers, we need to get JBoss "fixed". Until > > then, > >>I'd recommend a different approach than CMP. > > > My goal for the 4.0 architecture is to enable the easy use of a hybrid > approach to CMP. In this design you can use CMP for the 98% of you app > that performs well under the current code and for the 2% that needs hand > code you can plug in a custom interceptor to tune queries. > > -dain > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > -- xxxxxxxxxxxxxxxxxxxxxxxxxxxx | Emerson Cargnin | | Analista de Sistemas Sr. | | Tel : (051) 3358-4959 | | SICREDI Serviços | | Porto Alegre - Brasil | |xxxxxxxxxxxxxxxxxxxxxxxxxx| ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user This transmission contains information solely for intended recipient and may be privileged, confidential and/or otherwise protect from disclosure. If you are not the intended recipient, please contact the sender and delete all copies of this transmission. This message and/or the materials contained herein are not an offer to sell, or a solicitation of an offer to buy, any securities or other instruments. The information has been obtained or derived from sources believed by us to be reliable, but we do not represent that it is accurate or complete. Any opinions or estimates contained in this information constitute our judgment as of this date and are subject to change without notice. Any information you share with us will be used in the operation of our business, and we do not request and do not want any material, nonpublic information. Absent an express prior written agreement, we are not agreeing to treat any information confidentially and will use any and all information and reserve the right to publish or disclose any information you share with us. ------------------------------------------------------- This SF.net email is sponsored by: ApacheCon, November 18-21 in Las Vegas (supported by COMDEX), the only Apache event to be fully supported by the ASF. http://www.apachecon.com _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
