I’m not sure about the specifics of the database schema, but the indexing
matter was discussed in detail during August 2001 and following. Here are a
couple of links:
http://lists.fsck.com/pipermail/rt-users/2002-January/006103.html (I think
this addresses the second portion of your questions)
GeorgeFrom: Derek D. Martin [mailto:email@example.com]
Sent: Tuesday, May 07, 2002 11:28 AM
Cc: Rt-Users (E-mail)
Subject: Re: [rt-users] Proper Server for RT
also look at turing your database, I found that to be abuot 60% of my
speed issues, the rest was/is bad database design,specifically the
table (sorry jesse).
Can you comment on what tuning you’ve done to improve your
performance? Is it mainly indexing tables? Does RT set up table
indexes? If not, perhaps it should (I keep meaning to look at this,
but always get sidetracked before I get to it).
Perhaps you’d also care to comment on how the design of the database
might be improved, so that future releases can be improved (if someone
decides to look into it…)?
Lead Network Engineer
rt-users mailing list
Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
This email message may contain information that is confidential and
proprietary to Babcock & Brown or a third party. If you are not the
intended recipient, please contact the sender and destroy the original and
any copies of the original message. Babcock & Brown takes measures to
protect the content of its communications. However, Babcock & Brown cannot
guarantee that email messages will not be intercepted by third parties or
that email messages will be free of errors or viruses.