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

[Asif Iqbal]

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
http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08
There's no place like 127.0.0.1