You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@geronimo.apache.org by "Gianny Damour (JIRA)" <de...@geronimo.apache.org> on 2006/06/04 14:31:30 UTC
[jira] Updated: (GERONIMO-2074) CMP Issues two selects for each CMP
bean read operation
[ http://issues.apache.org/jira/browse/GERONIMO-2074?page=all ]
Gianny Damour updated GERONIMO-2074:
------------------------------------
Attachment: GERONIMO-2074.patch
I have just fixed two problems in TranQL related to prefetch group transformation of EJB-QL returning entities, e.g. SELECT OBJECT(o) FROM CMPEJB o, and caching of CMP entities across tx.
It is possible to have a single query for this primitive by defining a prefetching group for the the findByPrimaryKey finder and also addiing a inter tx cache for the QuoteEJB CMP, see attached plan.
> CMP Issues two selects for each CMP bean read operation
> -------------------------------------------------------
>
> Key: GERONIMO-2074
> URL: http://issues.apache.org/jira/browse/GERONIMO-2074
> Project: Geronimo
> Type: Bug
> Security: public(Regular issues)
> Reporter: Matt Hogstrom
> Assignee: Gianny Damour
> Fix For: 1.2
> Attachments: GERONIMO-2074.patch
>
> Number of executions = 84422
> Statement text = SELECT Q.symbol, Q.low, Q.open1, Q.volume, Q.price, Q.high, Q.companyName, Q.change1 FROM QuoteEJB Q WHERE Q.symbol = ?
> Number of executions = 84464
> Statement text = SELECT Q.symbol FROM QuoteEJB Q WHERE Q.symbol = ?
> This is running the PrimitiveServlet2EntityLocal. In this primitive a CMP Entity bean is selected and all fields referenced. Performance would be greatly improved if we only did the full select and avoided the round trip of two queries.
> The difference in counts is beause of a bug I'm chasing with Jencks re: some Tx failing.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira