Hello, George.
To fix this performance issue you need to create two indexes:
CREATE INDEX LocalUsers1 ON Users(EmailAddress);
CREATE INDEX LocalCGM1 ON CachedGroupMembers(MemberId,GroupId,Disabled);
Please, after each create operation run explain and send me results.
On 5/23/06, George
Hi,
Tickets are taking a very long time to draw on our RT install. After a
bit of digging, I've found it's the 'More about XYZ' box that lists
other tickets the user has open.
This query:
SELECT DISTINCT main.* FROM (((Tickets main JOIN Groups Groups_1 ON (
Groups_1.Instance = main.id))
