[rt-devel] RT 3.0rc1 - "Ticket Create" slow load issue RESOLVED

[Jesse Vincent]

On Tue, Mar 18, 2003 at 06:02:46PM +1030, Matthew J. Draper wrote:
> Apologies... After discovering that Users_Overlay.pm hadn't changed (or
> have I gone truly crazy? ;), I got a little over-zealous with my `grep
> -v`s on the diff output. :)

Sorry. the change was actually in code which calls Users. (inside of
html)

> RT is still running The Query From Hell when I try to comment/reply, and
> is still taking ~100sec to run it.

Actually, the query is a good deal simpler (not multiply joining on
CachedGroupMembers.

> My only other question: I'm using PostgreSQL at the moment, as I
> mentioned earlier. There doesn't appear to be a CachedGroupMembers4
> (although there is a 3)... Should I drop 3? Is 4 called something else
> in Postgres, or are the indicies set up completely differently in the
> two database environments?

Drop both 2 and 3. Tell me how that does. (That change made it into the
repo post cutting rc2.


-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.