Re: Performance of Unsorted Queries

2014-09-16 Thread Jürgen Wagner (DVT)
Depending on the size of the individual records returned, I'd use a decent size window (to minimize network and marshalling/unmarshalling overhead) of maybe 1000-1 items sorted by id, and use that in combination with cursorMark. That will be easier on the server side in terms of garbage collect

Re: Performance of Unsorted Queries

2014-09-16 Thread Michael Della Bitta
Performance would be better getting them all at the same time, but the behavior would kind of stink (long pause before a response, big results stuck in memory, etc). If you're using a relatively up-to-date version of Solr, you should check out the "cursormark" feature: https://wiki.apache.org/solr

Performance of Unsorted Queries

2014-09-16 Thread Ilya Bernshteyn
If I query for IDs and I do not care about order, should I still expect better performance paging the results? (e.g. rows=1000 or rows=1) The use case is that I need to get all of the IDs regardless (there will be thousands, maybe 10s of thousands, but not millions) Example query: http://doma