On Thu, Feb 11, 2016, at 09:33 AM, Matteo Grolla wrote: > Hi, > I'm trying to optimize a solr application. > The bottleneck are queries that request 1000 rows to solr. > Unfortunately the application can't be modified at the moment, can you > suggest me what could be done on the solr side to increase the > performance? > The bottleneck is just on fetching the results, the query executes very > fast. > I suggested caching .fdx and .fdt files on the file system cache. > Anything else?
The index files will automatically be cached in the OS disk cache without any intervention, so that can't be the issue. How are you sorting the results? Are you letting it calculate scores? 1000 rows shouldn't be particularly expensive, beyond the unavoidable network cost. Have you considered using the /export endpoint and the streaming API? I haven't used it myself, but it is intended for getting larger amounts of data out of a Solr index. Upayavira