Fetching a single row and producing objects, even if a chain of eagerly loaded
many-to-ones, is a relatively cheap operation, and it still sounds like network
overhead of rows is the main problem.If any columns fetch large binary
objects or large amounts textual data, that can take a long
Yes, I'm using polymorphic mappers. It's actually only 1 row -
querying the object by id. I have lazy=false for any referenced
objects to the one I'm querying for.
On Jun 26, 12:16 pm, Michael Bayer mike...@zzzcomputing.com wrote:
You have a tremendous amount of LEFT OUTER JOINS in there, and