[rt-users] crazy sql during "reply" action

Jamie Wilkinson jaq at spacepants.org
Mon Apr 14 00:59:34 EDT 2003


This one time, at band camp, Jesse Vincent wrote:
>You may want to follow the ongoing discussion of this issue on rt-devel.
>It's a known problem and it's being worked on.

I've just installed DBIx::SearchBuilder 0.81_02.  I can't see any noticeable
improvement in speed.

I ran vacuum full just before attempting the query.  It took 15 almost
exactly 15 minutes from the moment I clicked "Reply" until the page had
finished loading.  Postgres took about 13:53 in cpu time to complete the
query.

-- 
jaq at spacepants.org                           http://spacepants.org/jaq.gpg



More information about the rt-users mailing list