On Thu, Jun 09, 2005 at 04:42:13AM -0700, Maurice Yarrow wrote: > Ah, here is one more interesting issue: a performance issue that I had > when querying for records. The particular table has fields for > username, list name, and a blob of the data in the list. When I needed > to get all list names for a given user, performance was slow, because > the blobs were being recovered along with the username/list names. > For this, I decided to use JDBC. This, of course, put me outside > the context of the OpenEJB transaction processing, and is therefore > a little risky, but no information was being inserted, so I decided, > temporarily, to do it this way. With direct access to only the fields > I needed but not the blobs, performance dramatically improved. > At the time, I did try a helper (OpenEJB) bean that accessed the > indicated table, but did not request the blob. Performance was no > better than it was when getting the entire record. I took this to > mean that the blob was being requested even though my helper bean > did not ask for it. Still, I will need at some point to revisit > this issue, because my query will need to be transaction compliant.
Hey Bruce, can you help us with this one? Not sure what options are available in Castor JDO to deal with this. Thanks, David
