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
