On 5/18/06, Alexey G Misyurenko <[EMAIL PROTECTED]> wrote:
Ruslan Zakirov wrote:
> Yep, it's normal. I have code branch where I experiment with ideas on
> how to get rid of some useless groups.
>
Is any documents on the NET where I can read how to optimize (compact)
information on this tables or delete some information without risk?
You can use RTx::Shredder to delete tickets and other objects from RT.
I think you couldn't just delete those groups even with shredder as RT
now relies on them.
I ask because we have I big speed degradation.
$RT::Handle->BeginTransaction() from SetOwner from Ticket_Overlay.pm
take about 200 second to run.
DB & Apache allreade run on different servers.
> On 5/18/06, Alexey G Misyurenko <[EMAIL PROTECTED]> wrote:
>> Alexey G Misyurenko wrote:
>> > Hello!
>> >
>> > Is it normal that CachedGroupMembers table contain about 4'500'000
>> records?
>> >
>>
>> Also is it normal that table Group & Principal contain 2'000'000 records
>> (each one)?
>>
>> And is it normal that table Group containe record's
>> where field Name is like 'User {digits}'?
>>
>>
>> > rt: 3.4.4
>> > about: 500'000 tickets
>> > DB: Oracle
>> >
>>
>>
>> --
>> WBR, Alexey G Misyurenko ( MAG-RIPE | MMAGG-RIPN )
>> CTO of Caravan ISP http://www.caravan.ru
>> Phone: +7 495 3632252 Cell: +7 495 5082794
>> _______________________________________________
>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>> Community help: http://wiki.bestpractical.com
>> Commercial support: [EMAIL PROTECTED]
>>
>>
>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>> Buy a copy at http://rtbook.bestpractical.com
>>
>>
>> We're hiring! Come hack Perl for Best Practical:
>> http://bestpractical.com/about/jobs.html
>>
>
>
--
WBR, Alexey G Misyurenko ( MAG-RIPE | MMAGG-RIPN )
CTO of Caravan ISP http://www.caravan.ru
Phone: +7 495 3632252 Cell: +7 495 5082794
--
Best regards, Ruslan.
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
We're hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html
