SpamKarma and WP Performance

Comments

1. George says:

   3/27/2005 at 12:39 pm

   Earlier versions of Spam Karma did delete the comments. However, they changed this to fit with how WordPress 1.5 itself handles spam comments (storing them). The aim was to later use that data to improve the filter itself (a “learning” filter).
2. Somebaudy (2 comments.) says:

   3/27/2005 at 12:51 pm

   Which version of Spam Karma did you install ? If you did install the 2.0 alpha maybe you can use the current 1.X version that does not store comment.
3. Geof F. Morris (19 comments.) says:

   3/27/2005 at 1:52 pm

   Well, Somebaudy, as George notes, 1.20 forward in the 1.x branch still stores the comments.

   I think storing the comments is a worthwhile thing to do, although from a design perspective, I don’t know if it might not make sense to move spam to another database table. I’d have to think on that a while.

   I’d rather keep the spam around for Bayesian-filtering purposes, although perhaps duplicate triples [URL, IP, email] could be gleaned…
4. Carla (10 comments.) says:

   3/27/2005 at 2:39 pm

   For clearing out/evaluating spam comments, I’ve fallen in love with Coldforged’s Paged Comment Editing plugin.
5. dr Dave (2 comments.) says:

   3/28/2005 at 12:29 am

   SK1 used to add that FULLTEXT key to the comments table with 1.2… although it doesn’t do it any more (1.5 SQL schema changed, for some reason). But at that time, there wasn’t any issue of thousands of useless spams kept in the table… Indeed 50 megs is much too big…

   SK2 doesn’t create any key and will probably auto-purge every X days (keeping comments marked as spam is only interesting as a way to recover them in case a mistake has been done)… so things should be better…

   Then again, I am pretty sure both SK1 and SK2 bring some real PHP overhead… but I am afraid there is little way to make that disappear, at best I think I can optimize it to keep it under control and bring it to the same level as other plugins or built-in tasks (for now, it seems to add about 1-2 seconds to the comment posting process… but I will soon add exact benchmarking functions to keep track of this).
6. Jim (2 comments.) says:

   4/13/2006 at 7:00 pm

   I’ll try spamkarma then. Is this why many of my trackbacks do not work?
7. Carlos (1 comments.) says:

   11/3/2007 at 7:59 pm

   I’ve just noticed that SK2 was guilty for slowing my comments posting system, and i’ve reached this blog looking for more information on how to deal with this.

   At the moment, with 2700 comments on my database and over 7000 of spam comments caught (and kept) by SK2, it takes more than 60secs to post a comment on my blog.
   I’ve emptied Sk2 spam table and it keep slowing down my comments.

   I know that this is because of SK2 because when i disable it, it all works perfectly. What else can i do? I didnt empty sk2_blacklist (1500 records), and i think that i souldn’t.

   Any suggestion?

Trackbacks/Pingbacks

1. Blogging Pro » Blog Archive » SpamKarma and WP Performance says:

   3/27/2005 at 1:00 pm

   […] ve used Spam Karma in the past but are not using it any longer Weblog Tools Collection has some tips for increasing WordPress performance after deleting […]
2. What makes you happy ? » Playing with the database says:

   3/27/2005 at 7:06 pm

   […] that he noticed an issue with his blog slowing down, and he pondered whether it was due to spam-karma. Having an excuse to mess with the database was a […]
3. centripetalforces dot com says:

   3/27/2005 at 10:33 pm

   Warp Speed Mr Sulu.

   There’s a short but useful tip over at the ‘weblogtoolscollection’ about cleaning up after SpamKarma is removed.

   SpamKarma is a great anti-spam plug-in, but I found it was a little too aggressive, hitting most commenter’s with…