Hello Matt,
I think that to do that for FindByPrimaryKey is rather simple. Yet, it
would be a non-optimal patch as it does not solve the problem as a whole.
As a matter of fact, I have started to work on CMP and CMR prefetching
(see http://issues.apache.org/jira/browse/GERONIMO-665 for more
details). Based on my current estimates, you should expect something
working by end of next week.
Meanwhile, if you want to give us a hand with respect to database
operations, here are two things that I think we want to have:
* batch updates: I think that this is an easy one and a good way to get
started with TranQL; and
* cache across transactions: I think that it is much more complex.
Please note that I am happy to provide my support if you want to work on
any of these two items.
BTW, have you been able to identify the problem associated to the
java.sql.Date field?
Thanks,
Gianny
On 8/06/2005 12:36 PM, Matt Hogstrom wrote:
I've been testing FBK and found that there are two queiries being
executed. First a SELECT is done against the PK for the bean and that
is followed by a SELECT for the columns of the bean. Performance can
be improved by executing the second query only and getting the PK and
all the coluns in one shot. Can we make the defulat for FBK and EJBQL
queries to get all the data straight away as the default.
Is this a simple change?
