AFAIK only findByPrimaryKey queries are optimised to look first in memory. All others at least fetch the pk values from the db.

david jencks

On Tuesday, January 28, 2003, at 03:11 PM, Eric J Kaplan wrote:

I had asked this a little while ago but got no response.  Any takers?  If the answer is the container will be smart enough to know the set is already in memory, is this a jboss specific feature or“part of the spec”

Regards

Eric

-----Original Message-----
From:Eric Kaplan [mailto:[EMAIL PROTECTED]]
Sent:Thursday, January 23, 2003 11:45 AM
To:Jboss-User
Subject:question about jboss cmp


Consider a cmp bean that has in it a date and a unique transaction id.

Now let's say you have the need to find all beans between two dates, 1/1/01 through 1/1/03.

Let's then say someone else comes along and wants to find all beans between two other dates, 1/1/02 through 1/1/03.

What will the container do?  Is it smart enough to know the set is already in memory?

If so, if someone then asks for 1/1/00 through 1/1/03, what does it do?  Get all again?  Just get 1/1/00 through 12/31/00?

Eric Kaplan

Armanta, Inc.

Reply via email to