[rt-devel] Re: [rt-users] 100 SELECT queries to display just one ticket

[Jesse Vincent]

On Sun, Aug 17, 2003 at 11:50:20PM -0400, Asif Iqbal wrote:
> Hi All
> 
> I noticed when I turned on the mysql log in the mysqld startup script it was
> showing  about 100 select commands just to display one ticket.
> 
> Has anyone else noticed this ? Is it normal for RT-3-0-4 ? Is that why my RT is
> sooooo slow -- about 20+ secs to display one ticket.

There are definitely ways we can cut down on the number of SQL queries
used to display ticket output.  Generally, well-tuned systems don't need
that level of tweaking and when we've worked on customer systems, we've
never needed to resort to that optimization path. 20 seconds for ticket
display implies that there's something wrong with your database config
(where a missing index might count).



> I am using Solaris 8 (sparc)/MySQL 4.0.13/Perl 5.8/Apache
> 1.3.x/mod_perl1/RT 3-0-4
> 
> I am also using my-medium.cnf for my 4x450Mhz/4gig system

I think for mysql's purposes, you really want a hand-tweaked
my-large.cnf. 


> I added index, as found in rt-users mailing list, for the GroupId and MemberId
> column of CachedGroupMembers Table. It seemed to improved it from 35+ secs to
> 20+ secs for per ticket query
> 
> Thanks ahead for any suggestions
> 
> -- 
> Asif Iqbal
> http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08
> There's no place like 127.0.0.1
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
> 

-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.