We are having problems with slow queries in our MySQL model database. We are running EA 7.5.848 with ClearCase for version control.
From looking at the slowquery log, we occaisionally see over 120 seconds for for the following query to run:
Select t_xref.`Type`, client.Object_ID as ClientID, client.Name as ClientName, client.Object_Type as ClientType, supplier.Object_ID as SupplierID, supplier.Name as SupplierName, supplier.Object_Type as SupplierType from t_xref, t_object client, t_object supplier where t_xref.Client = client.ea_guid and t_xref.Supplier = supplier.ea_guid;
I think that it is triggered whenever someone performs a check-out or GetLatest.
It is probably taking so long as it is searching through 101925 rows of data in order to match up the client.ea_guid and the supplier.ea_guid.
Would the client be EA package and the supplier ClearCase maybe?
Does anyone have any input of what is going on here? I'm wondering if ea_guid isn't indexed.
