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

[Ham MI-ID, Torsten Brumm]

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


Kuehne + Nagel (AG & Co.) KG, Geschaeftsleitung: Hans-Georg Brinkmann (Vors.), Uwe Bielang (Stellv.), Bruno Mang, Dirk Blesius (Stellv.), Alfred Manke, Christian Marnetté (Stellv.),  Mark Reinhardt (Stellv.), Jens Wollesen, Rainer Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Persoenlich haftende Gesellschaft: Kuehne & Nagel A.G., Sitz: Contern/Luxemburg Geschaeftsfuehrender Verwaltungsrat: Klaus-Michael Kuehne



________________________________

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://rt3.fsck.com/> .
		

		_______________________________________________
		http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
		
		Community help: http://wiki.bestpractical.com <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 <http://rtbook.bestpractical.com/> 
		




	-- 
	MFG
	
	Torsten Brumm
	
	http://www.torsten-brumm.de <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/20090124/98b66ae6/attachment.htm>