Context Navigation

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

initial	v1
7	7	Now with that said -- I haven't seen any complaints with regards to performance for the != trash.
8	8
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.
	9	So 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.
10	10
11	11	I'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.