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

Asif Iqbal iqbala at qwestip.net
Sun Aug 17 23:50:20 EDT 2003

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.

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 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
There's no place like

More information about the Rt-devel mailing list