It really shouldn't make a difference. So if you fetch the data outside Cayenne using MySQL client, which row is missing if you fetch
SELECT `t0`.*, `t2`.`employee_id` FROM `scheduler_position` `t0` JOIN `scheduler_employee_position` `t1` ON (`t0`.`position_id` = `t1`.`position_id`) JOIN `scheduler_employee` `t2` ON (`t1`.`employee_id` = `t2`.`employee_id`) WHERE (`t2`.`customer_id` = ?) AND (`t2`.`is_enabled` = ?) vs. just SELECT `t0`.* FROM `scheduler_position` `t0` ? Thanks, Andrus On Jul 20, 2011, at 12:06 AM, Tad wrote: > I solved the issue by setting JOINT_PREFETCH_SEMANTICS on the > prefetch. Why should this make a difference? > > -- > Thanks! > Tad >
