[rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI

[kem cho]

Hi,
This works really well, even with RT 3.8.1. I will test this with 3.8.2 sometime this week, and post the results.
Thanks for your help... 

--- On Sat, 1/24/09, Ham MI-ID, Torsten Brumm <torsten.brumm at Kuehne-Nagel.com> wrote:

From: Ham MI-ID, Torsten Brumm <torsten.brumm at Kuehne-Nagel.com>
Subject: AW: [rt-users] Strange,long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI
To: kemcho12345 at yahoo.com, torsten.brumm at googlemail.com
Cc: rt-users at lists.bestpractical.com
Date: Saturday, January 24, 2009, 2:37 AM



Hi Kem,
make first a local copy of /rthome/share/html/Search/Bulk.html to /rthome/local/html/Search/Bulk.html
 
Then open local Bulk.html and search for: 
 
<tr><td class="label"> <&|/l&>Make Owner</&>: </td>

Then replace the Line: 
 
<td class="value"> <& /Elements/SelectOwner, Name => "Owner" &> (<input type="checkbox" class="checkbox" name="ForceOwnerChange" /> <&|/l&>Force change</&>) </td></tr>

With:
 
<td class="value"> <input name="Owner" size="20" /> (<input type="checkbox" class="checkbox" name="ForceOwnerChange" /> <&|/l&>Force change</&>) </td></tr>

 
Torsten
 
And now. my bulk update page is from 200sec down to 0,5sec !!!
 
Thanks for any hints so far
 
Torsten



Kühne + Nagel (AG & Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann (Vors.), Uwe Bielang (Stellv.), Dirk Blesius (Stellv.), Bruno Mang, Alfred Manke, Christian Marnetté (Stellv.), Mark Reinhardt (Stellv.), Jens Wollesen, Rainer Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Persönlich haftende Gesellschaft: Kühne & Nagel A.G., Sitz: Contern/Luxemburg, Geschäftsführender Verwaltungsrat: Klaus-Michael Kühne 



Von: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] Im Auftrag von kem cho
Gesendet: Freitag, 23. Januar 2009 18:41
An: torsten.brumm at googlemail.com
Cc: rt-users at lists.bestpractical.com
Betreff: Re: [rt-users] Strange,long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI







Do you know which file controls this drop down box? "...replacing the dropdown with a normal textbox..."
 
I am having exactly the same problem, but cannot find which file / code is controlling this. 
 
Thanks for your help. 


--- On Fri, 1/23/09, Torsten Brumm <torsten.brumm at googlemail.com> wrote:

From: Torsten Brumm <torsten.brumm at googlemail.com>
Subject: Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI
To: "Emmanuel Lacour" <elacour at easter-eggs.com>
Cc: rt-users at lists.bestpractical.com
Date: Friday, January 23, 2009, 9:01 AM


Hi Emmanuel,
now back home and try on monday. so it is coming form the SelectOwner Dropdown? I remember some years ago something similar at the querybuilder page and i think jesse fixed this by replacing the dropdown with a normal textbox...will try it out and keep you up2date.

Have a nice weekend

Torsten 


2009/1/23 Emmanuel Lacour <elacour at easter-eggs.com>


On Fri, Jan 23, 2009 at 03:37:17PM +0100, Emmanuel Lacour wrote:
>
> But ... we can probably reduce the list of owners to those corresponding
> to the list of queues displayed in Elements/SelectQueues instead of all
> Owners of the RT system.
>

humm I'm a bit busy now, I open a bug for you to try to enhance this on
rt3.fsck.com.




_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales at bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com



-- 
MFG

Torsten Brumm

http://www.torsten-brumm.de
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales at bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090125/03649c7d/attachment.htm>