[rt-users] Query Builder very slow after system update

[Tim Cutts]

On 24 Apr 2009, at 3:13 pm, Liviu Costea wrote:

> Hello,
>
> We recently updated our RT3 server ( RT 3.8.1 , around 200000  
> tickets) from Red Hat Enterprise Linux 5.1 to 5.3 (yum update). The  
> new MySQL installed version is 5.0.45.

We massively sped up the Query Builder by overriding the PickBasics  
element:

--- /opt/rt3/share/html/Search/Elements/PickBasics	2009-02-03  
11:53:01.000000000 +0000
+++ ./html/Search/Elements/PickBasics	2009-02-10 15:38:44.000000000  
+0000
@@ -121,11 +121,10 @@
              Path => '/Elements/SelectBoolean',
              Arguments => { TrueVal=> '=', FalseVal => '!=' },
          },
-        Value => {
-            Type => 'component',
-            Path => '/Elements/SelectOwner',
-            Arguments => { ValueAttribute => 'Name' },
-        },
+	Value => {
+	    Type => 'text',
+            Size => 20,
+	},
      },
      {
          Name => 'Watcher',

It's the SelectOwner dropdown box which takes so long to populate with  
a large number of users in the system, so we just changed it to a text  
input box.  Can't take credit for this - a previous poster pointed  
this out a couple of months ago.

Tim


-- 
 The Wellcome Trust Sanger Institute is operated by Genome Research 
 Limited, a charity registered in England with number 1021457 and a 
 company registered in England with number 2742969, whose registered 
 office is 215 Euston Road, London, NW1 2BE.