Now that I look closer, it does look like it is just loading PKs. Thanks for helping me see that.
-H > From: Stephen Coy <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Tue, 10 Dec 2002 14:34:15 +1100 > To: [EMAIL PROTECTED] > Subject: Re: [JBoss-user] EJB Commit Option A Cache Question > > Hi, > > Are the queries that you are seeing just loading primary keys, or are > there other columns present as well? > > I think it's normal for JBoss to continue to issue queries for the pks, > after which it uses the associated cache data. > > If you are seeing other columns in the queries, then you may be using > the "on-find" read-ahead strategy, which I think often defeats the > purpose of using "Commit Option A". > > I can see a case for optimising away the "findAll" query, but I don't > think JBoss does this. Also, we found that we nearly always use > jboss-ql for these anyway, so that we can specify the ordering. So, a > query for the pks to provide ordering is required in any case. > > Steve Coy > > > On Tuesday, December 10, 2002, at 10:26 AM, Hunter Hillegas wrote: > >> I have an application that uses CMP Entities in Commit Option A. I am >> testing it on JBoss 3.2 beta 2. >> >> The app uses session facades and servlet+JSP to display the data. >> >> I have a JSP page that displays a list of hotels. It includes a >> servlet that >> calls a SLSB to do a findAll() on the Hotel entity. The SLSB returns >> value >> objects that represent the entities. >> >> I have my database logging turned all the way up so I can see what >> queries >> are executing. >> >> The first time I run this, I see a query that loads all of the >> entities. >> This is to be expected. >> >> The thing is, I see this on subsequent requests as well. Shouldn't >> this all >> be in the CMP cache since I am using option A? Why would it be going >> back to >> the database? >> >> Trying to figure out if we have a design problem with our application. >> >> Thanks, >> Hunter >> >> >> >> ------------------------------------------------------- >> 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 ------------------------------------------------------- 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
