[rt-users] RT Performance, Hardware

[Manfred Hui]

By the way, please backup your data before playing with the indexes.

Manfred.


----- Original Message -----
From: "Nate Amsden" <subscriptions at graphon.com>
To: <rt-users at lists.fsck.com>
Sent: Wednesday, June 26, 2002 5:12 AM
Subject: Re: [rt-users] RT Performance, Hardware


> Manfred Hui wrote:
> >
> > It should only take a few seconds to load a ticket, (we have around
30000
> > tickets, mysql, P3 600, 512 mb ram)
> >
> > Check that you have indexed the tables correctly, especially Tickets,
> > Transactions and Attachments.
>
> does this apply to only postgres ? i have a system running mysql and with
1000
> tickets its dog slow, some tickets take over a minute to load. p3-600 1gb
ram.
>
> can you point me to docs that talk about indexing the tables ? i haven't
used
> rt directly much yet(others on the network do) but i have been maintaining
> the 'back end' for a while.
>
> thanks!!
>
> nate
>
> --
> Nate Amsden
> System Administrator
> GraphOn
> http://www.graphon.com
>
> _______________________________________________
> 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
>
>