I'm experiencing crazy slow query times since I updated to this version. The only thing I see is that it's structuring the queries slightly differently. For example: 4.1.M3-SNAPSHOT:
SELECT DISTINCT t0.birthday, t0.contact_id, t0.contact_lead_source, t0.contact_status, t0.create_date, t0.glove_user, t0.graduation_date, t0.name_first, t0.name_last, t0.name_middle, t0.name_prefix, t0.name_salutation, t0.name_tag, t0.national_provider_id, t0.notes, t0.professional_designation, t0.specialty FROM customer.dbo.contact t0 *JOIN* customer.dbo.contact_affiliations t1 ON (t0.contact_id = t1.contact_id) WHERE t1.company_id = ? AND t1.contact_id = ? and now: SELECT DISTINCT t0.birthday, t0.contact_id, t0.contact_lead_source, t0.contact_status, t0.create_date, t0.glove_user, t0.graduation_date, t0.name_first, t0.name_last, t0.name_middle, t0.name_prefix, t0.name_salutation, t0.name_tag, t0.national_provider_id, t0.notes, t0.professional_designation, t0.specialty FROM customer.dbo.contact t0 *LEFT JOIN* customer.dbo.contact_affiliations t1 ON t0.contact_id = t1.contact_id WHERE *( ( t1.company_id = ? ) AND ( t1.contact_id = ? ) )* The only thing I can think is that Sybase's (my DB) query optimizer isn't happy with the LEFT JOIN. In DbPathProcessor it's always specifying a JoinType.LEFT_OUTER for relationship joins...this doesn't seem right to me, but I might be misunderstanding what's going on. Thoughts? -Lon
