[rt-devel] 100 SELECT queries to display just one ticket
iqbala at qwestip.net
Sun Aug 17 23:50:20 EDT 2003
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
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
There's no place like 127.0.0.1
More information about the Rt-devel