Duplicate checking for nodes / comments has come and gone and hopefully it'll come back soon for D6.
All along though, there has been an expensive query that lives deep within comment.module offering no real intrinsic value and slowing down sites everywhere.
This patch removes this query that adds a warning to watchdog about a duplicate comment.
This warning offers no real value and a patch that addresses duplicates at the form level would do a much better job. This is just a first, easy step.
Here's a more detailed look at the performance implications of that query: http://drupal.org/node/134139
Comments
Comment #1
m3avrck commentedAnd the patch...
Comment #2
catchI see no reason to have a watchdog notice about duplicate comments if duplicates can be avoided via other methods. I must have had dozens of duplicate comments on my site, and never noticed the error in the watchdog amongst everything else that goes in it.
The patch is very simple, simply removing this query from the module altogether.
So +1.
Comment #3
david straussI'll give this a +1. The query could be optimized, but the warning just isn't that useful to begin with.
Comment #4
catchsimple and good. It's a hopefully-soon-to-be-redundant warning that almost no-one ever sees.
Comment #5
dries commentedCommitted to CVS HEAD. Thanks.
Cannot be backported to DRUPAL-5.
Comment #6
(not verified) commented