geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeremy Boynes <jboy...@apache.org>
Subject Re: CMP FBPK Yields an individual SELECT per column
Date Thu, 08 Sep 2005 19:24:28 GMT
Aaron Mulder wrote:
> 	I think the prefetch default should be "all columns" not "only 1
> column".  I see a lot more small/normal tables than tables with giant
> BLOBs or 100s of columns, so it makes much more sense to me to force the
> user to optimize for giant tables (default to load all CMP) than to force
> the user to optimize for every table (default to load 1 at a time).
> 

I agree - what you're seeing is TranQL's default when the front-end 
doesn't tell it what to do. I would suggest OpenEJB set this up as follows:

* CMP1 - load all
* CMP2 - load everything that isn't a LOB and let those fault in

--
Jeremy

Mime
View raw message