[Rt-devel] 3.4.1 perf problem

[Alexander Finger]

Hi,

this request was the last in the mysql-slow.log when I had to nothalt 
the db today:

SELECT COUNT (DISTINCT main.id) FROM
    (
        (Tickets main  LEFT JOIN ObjectCustomFieldV  alues 
ObjectCustomFieldValues_1  
        ON (
                (ObjectCustomFieldValues_1.ObjectType = 'RT  ::Ticket')
            )
        AND (
                (ObjectCustomFieldValues_1.Disabled = '0')
                )
        AND (  
                main.id = Obj  ectCustomFieldValues_1.ObjectId
                )
            )  
        JOIN CustomFields CustomFields_2  ON
        ( Object  CustomFieldValues_1.CustomField = CustomFields_2.id)
        AND( (CustomFields_2.Name =   'NAS-ID')))   
        WHERE ((main.EffectiveId = main.id)) AND ((main.Status != 
'delete  d'))
        AND ((main.Type = 'ticket'))
        AND ((main.Status = 'open')OR(main.Queue = '25  ')
        OR(ObjectCustomFieldValues_1.Content LIKE '%HIT387721%')
    );

Any hints for optimization?


thanks
Alex