Re: Sort speed asc vs desc - is desc slower?

2012-12-12 Thread Yonik Seeley
On Wed, Dec 12, 2012 at 5:49 PM, Michael Ryan mr...@moreover.com wrote: When sorting a TrieLongField, should there be any expected difference in query speed when sorting ascending vs sorting descending? I'm seeing desc queries sometimes take 10x longer than asc queries. I can provide more

RE: Sort speed asc vs desc - is desc slower?

2012-12-12 Thread Michael Ryan
Perhaps if there are a lot more ties on one end vs the other? Or of the values being sorted on aren't that random? Do they naturally increase like a timestamp? It's a unique id field. The id is a simple sequential id, so docs with a lower doc id will naturally also have a lower id. I think