WordPress.org

Make WordPress Core

Changes between Initial Version and Version 1 of Ticket #14222, comment 10


Ignore:
Timestamp:
04/06/11 19:45:34 (4 years ago)
Author:
nacin
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #14222, comment 10

    initial v1  
    77Now with that said -- I haven't seen any complaints with regards to performance for the != trash. 
    88 
    9 So we should either copy.move that to != 'spam', or NOT IN for both trash and spam, which shouldn't be much slower. There's going to be more spam comments than trash comments on pretty much every site, as spamming is going to be automated (and in far greater volumes), so I'm strongly inclined to deal with this one way or another now. 
     9So we should either copy or move that to != 'spam', or NOT IN for both trash and spam, which shouldn't be much slower. There's going to be more spam comments than trash comments on pretty much every site, as spamming is going to be automated (and in far greater volumes), so I'm strongly inclined to deal with this one way or another now. 
    1010 
    1111I've also opined here that increasing the limits (both initial, and the jump) on successive queries makes a lot of sense. We should do that improvement as well.