[rt-devel] RT 2.0.9pre1, DBIx::SearchBuilder 0.46 mof_fastcgi Performance

[Rich West]

Running 2.0.9pre1 now.  No obvious visible differences (of course, I 
didn't look too hard :)

Interestingly, I still do not get the rt.jpg image.. that, and it 
doesn't install the rt.jpg file into NoAuth/images when a "make upgrade" 
is performed..

Just thought I would mention that, during either the install of 2.0.8 or 
2.0.9pre1, I saw "Warning: prerequisite DBIx::SearchBuilder 0.46 not 
found at /usr/local/lib/perl5/5.6.1/ExtUtils/MakeMaker.pm line 340."

I have the DBIx::Searchbuilder 0.46-test1 (from the CVS tree) 
installed... Hrmm.

The main deal for doing the 2.0.9pre1 and Searchbuilder upgrades was to 
beat up on the massive delay for any interaction to RT2. On top of that, 
I did those optimizations to MySQL (both on the INDEX side of the house 
and the mysqld running options), but it still takes about 5-10 seconds 
to even draw the log in screen.

Any other ideas as to how to trim down the delays?  (Solaris 8, Apache 
1.3.22, mod_fastcgi, MySQL 3.23.43 (on a separate host))

-Rich


Jesse Vincent wrote:

>The new SearchBuilder should fix perf issues with mysql and some issues
>with query generation on postgres
>
>There are a number of minorish bug fixes that need to get into 2.0.9.  
>I'll be trying to get to those in the next week or two.
>
>This new RT prerelease includes the following:  
>
>	Bumped version to 2.0.9pre1
>	
>	file cvs_integration was initially added on branch rt-1-1.
>	
>	Refactored images path to have a configurable URL, so it will work with fastcgi ;)
>
>	Added support for timing of page display with &Debug=1
>	
>	User.pm: a fix to allow you to create multiple users with no email address.
>	
>	Added sub Due to Tickets.pm. fixes #910
>
>	Some work on the rpm build infrastructure
>
>	Added cpan2rpm to the tools directory, for autogenerating rpms of cpan modules
>	
>	Added support for autobuilding an rpm with "make rpm"
>
>	Fixed templates to include the ticket subject if it was otherwise blank
>	
>	work on web-based ticket creation. fixed bugs setting due dates, etc
>	
>	fixed a user creation race condition in the mail gateway
>
>	use the new status abstraction in the web ui
>	
>	moved to a dbix::searchbuilder 0.46 dependency
>	
>	now initdb won't whine if you don't set a host
>	
>	Added some docs about what 2.2 might hold
>	
>	Abstracted out status enumeration and validation
>	
>	added WebPath to fix some links in showlinks
>	
>	Added an optional bit of configuration to not show the "History" header
>	
>	Added a new option "Show commands" to show tranasaction
>	
>	Added support for reenabling deleted queues and keywords
>	
>	Added test harness glue
>	
>	Added code to detect bogus ticket update types
>	
>	Added support for unit testing
>	
>	Added a test for Database Port definition to stop perl from whining
>
>	Added the beginnings of test support to RT.pm
>	
>	bin/rt: Documentation cleanups. removing an unnecessary data tainting check
>	Fixes to initacls.Pg to allow installation with Unix Domain sockets
>
>

-- 
Richard West                   $14.95 Registrations      mailto:rwest at wesmo.com
Wesmo Computer Services        .com .net .org .tv .cc    http://www.wesmo.com
Full Domain & Web Hosting      .BIZ .INFO & MORE!!