Hey all, I'm working on optimizing my query times, and I was wondering if there's any secrets to improving sort time. Let me emphasize that I'm working on __cold__ query times. I'm intentionally trying to simulate cache misses and I'm aware that caching would improve my times greatly. Here's my situation:
I'm using the all query *:* with a few filter queries (type:stuff, userId:12345, category:3, etc). Without sorting, my query takes about 600ms, which is fine for me. My target range is 500-1000ms. When I add a sort field, my query takes about 53,000ms, which seems ridiculous. The field I'm sorting on is a sortable long with omitNorms=true. My index has around 2M docs and my configuration is the default. Is this simply the initial price to pay for using a sort field, or is there any way I can improve my cold query time? Matt
