On 2/17/2016 3:49 PM, Mark Robinson wrote: > I have around 121 fields out of which 12 of them are indexed and almost all > 121 are stored. > Average size of a doc is 10KB. > > I was checking for start=0, rows=1000. > We were querying a Solr instance which was on another server and I think > network lag might have come into the picture also. > > I did not go for any caching as I wanted good response time in the first > time querying itself.
Stored fields, which contain the data that is returned to the client in the response, are compressed on disk. Uncompressing this data can contribute to the time on a slow query, but I do not think it can explain 30 seconds of delay. Very large documents can be particularly slow to decompress, but you have indicated that each entire document is about 10K in size, which is not huge. It is more likely that the delay is caused by one of two things, possibly both: * Extremely long garbage collection pauses due to a heap that is too small or VERY huge (beyond 32GB) with inadequate GC tuning. * Not enough system memory to effectively cache the index. Some additional info that may be helpful in tracking this down further: * For each core on one machine, the size on disk of the data directory. * For each core, the number of documents and the number of deleted documents. * The max heap size for the Solr JVM. * Whether there is more than one Solr instance per server. * The total installed memory size in the server. * Whether or not the server is used for other applications. * What operating system the server is running. * Whether the index is distributed or contained in a single core. * Whether Solr is in SolrCloud mode or not. * Solr version. Thanks, Shawn
