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
