[rt-users] Proper Server for RT

[George Warnagiris]

Hello Derek,

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/2001-August/003758.html

http://lists.fsck.com/pipermail/rt-users/2002-January/006103.html (I think
this addresses the second portion of your questions)

George

-----Original Message-----
From:	Derek D. Martin [mailto:ddm at skillsoft.com]
Sent:	Tuesday, May 07, 2002 11:28 AM
To:	Mat
Cc:	Rt-Users (E-mail)
Subject:	Re: [rt-users] Proper Server for RT

On Tue, May 07, 2002 at 07:53:08AM +1000, Mat wrote:
> 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
watchers
> 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...)?


-- 
Derek Martin
Lead Network Engineer
ddm at skillsoft.com
(603)324-3000 x516

_______________________________________________
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



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.