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.
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [email protected]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
