Automatically Permanently Delete

[John Elliott]

There's a person called accountmaker1337@googlemail.com that uploads viruses to several news groups I visit. I'd like to be able to permanently delete ALL of his posts automatically with an Automation Rule. I'm using an Automation Rule now, but it only sends his posts to the trash. He actually uploads about 13,376 of these (or more) viruses per 12 hours to alt.binaries.multimedia, and alt.binaries.tv, combined. If there's currently a way to do that, I haven't found it.
Thanks.

[BZB]

The database doesn't work that way. When you delete something, it is moved to the trashcan. It doesn't actually get taken out of the database until you run a purge.

IIRC, it was decided a while back that it was not reasonable to do a realtime delete/purge every time you deleted something, as it would cause long delays.

What you're suggesting actually won't make much difference anyway, as you're only talking about deleting headers. What you're doing now (dumping them in the trash via an automation rule and then purging them along with your normal purge) is actually a pretty efficient way to deal with these headers.

[administrator]

Furthermore, doing a permanent delete after every found header would take forever. Batching thing together the way purging does is much, much faster.

Regards

[canrith]

[administrator]

No, it isn't normal. I purge around 150,000 headers (according to trash), which includes about 3,000,000 segments (number of actual headers), every day in less than 8 minutes.

I'd see if you can determine what other processes may be interfering with MySQL doing its thing. Could be that your antivirus is slowing it way down.

Also, if your database is really, really big, and you are only purging a small fraction of the headers in your database, it can take longer, but I'd say anything over 30 minutes is way too long.

Regards

[BZB]