[rt-users] Rtx::Shredder: Indexes for Performance improvements on deleting Tickets

2007-04-11 Thread Dirk Pape
Hello, using Shredder Version 0.6 with rtx-shredder --plugin Tickets=limit,50;status,deleted;updated_before,`date -I -d '1 month ago'` --force I added the following indexes, that improved purging deleted Tickets from 3 hours to one minute. on Transactions: KEY `Shredder`

Re: [rt-users] Rtx::Shredder: Indexes for Performance improvements on deleting Tickets

2007-04-11 Thread Mathew
From three hours to one minute? I'll definitely have to test that out because, quite frankly, I'm skeptical. I only hope it's true :) How many tickets do you typically shred per run? Mathew Dirk Pape wrote: Hello, using Shredder Version 0.6 with rtx-shredder --plugin

Re: [rt-users] Rtx::Shredder: Indexes for Performance improvements on deleting Tickets

2007-04-11 Thread Dirk Pape
Hello --Am 11. April 2007 11:53:22 -0400 schrieb Mathew [EMAIL PROTECTED]: How many tickets do you typically shred per run? 50 Dirk. -- Dr. Dirk Pape (eAS - Projektleitung Campus Management) Freie Universitaet Berlin Grunewaldstr. 34a, 12165 Berlin Tel. +49 (0)30 838 75143, Fax. +49 (0)30

Re: [rt-users] Rtx::Shredder: Indexes for Performance improvements on deleting Tickets

2007-04-11 Thread Ruslan Zakirov
Dirk, have you read changelog? http://search.cpan.org/~ruz/RTx-Shredder-0.06/lib/RTx/Shredder.pm#Database_indexes On 4/11/07, Dirk Pape [EMAIL PROTECTED] wrote: Hello, using Shredder Version 0.6 with rtx-shredder --plugin Tickets=limit,50;status,deleted;updated_before,`date -I -d '1 month

Re: [rt-users] Rtx::Shredder: Indexes for Performance improvements on deleting Tickets

2007-04-11 Thread Ruslan Zakirov
On 4/11/07, Dirk Pape [EMAIL PROTECTED] wrote: Hello, using Shredder Version 0.6 with rtx-shredder --plugin Tickets=limit,50;status,deleted;updated_before,`date -I -d '1 month ago'` --force I added the following indexes, that improved purging deleted Tickets from 3 hours to one minute. on