[rt-users] RTx::Shredder time gap between tickets wipeout

[Konstantin Naryzhniy]

So, well, do you suggest that I reinstall Shredder?
Not quite sure how to uninstall it once it's up...

If you commit things once - what event do "warning <object-id> wiped out"
lines refer to in the log? And how many times the dump file is written per
one top level object?

I also plan to try running Shredder with Postfix and Apache off. I slightly
hope that that'll speed things up a bit, since there's going to be no
queries committed simultaneously with Shredder.

I'll report on results of this.

Ruslan, thanks again for your great tool!

Kostya

-----Original Message-----
From: Ruslan Zakirov [mailto:ruslan.zakirov at gmail.com] 
Sent: Friday, March 16, 2007 6:56 PM
To: Konstantin Naryzhniy
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] RTx::Shredder time gap between tickets wipeout

On 3/16/07, Konstantin Naryzhniy <konstantinn at parallels.com> wrote:
> Hello Ruslan!
> Thanks for your rapid reply.
>
> I have added one of the indices you've suggested (we do not have Custom
> Fields yet and the ACL table is relatively small and doesn't appear in
slow
> queries log).
>
> I do not think that the delay is caused by the committing transaction.
> Actually, the gap has to deal with the previous ticket, rather that the
next
> one. I mean that this delay first happens right after when I confirm the
"Do
> you want to proceed? [y/N]" prompt and before the first warning line
> appears.
Huh, that's kinda a ringing bell that's I've screwed up something and
that's actually problem in the shredder.

>
> Could you please explain what happens before the first warning is sent to
> output? I am no programmer to dig into the source code))
>
> Are the DELETE statement in the Shredder committed one by one or are they
> committed in a single "package" after all the records in DB tables were
> found?
I commit things once per ticket or per user, depends on what top level
objects are. Top level objects are objects you select with a plugin.

>
> thanks,
> Kostya