Prev Next

Web / Apache Solr Interview questions

How does Solr handle deep pagination, and why is cursorMark recommended over start/rows?

Standard pagination with start and rows looks simple - start=10000&rows=20 for page 501 - but internally Solr, like any Lucene-based system, still has to compute and rank the first 10,020 results and discard the first 10,000 just to return the requested 20. As start grows, this becomes increasingly expensive in both CPU and memory, and in a distributed SolrCloud collection every shard must independently compute up to start + rows results before the coordinator merges and trims them.

/select?q=*:*&sort=id+asc&cursorMark=*&rows=20

cursorMark avoids this by treating pagination as a stateful walk rather than a random-access offset. Instead of "skip N and take the next page," each response returns a nextCursorMark token encoding the sort values of the last document seen. The next request passes that token back, and Solr resumes exactly where it left off using an efficient index seek, with cost that stays roughly constant regardless of how deep into the result set you are.

The trade-off is that cursorMark requires a fully deterministic sort that includes the unique key as a tiebreaker (e.g. sort=score desc, id asc), and it only supports moving forward through results, not jumping to an arbitrary page number - which fits "infinite scroll" and export/crawl use cases better than a classic numbered page control.

Why does a large start value hurt performance with classic start/rows pagination?
What must the sort parameter include for cursorMark to work correctly?

More Related questions...

What is Apache Solr? What are the types of fields in Solr? What is a Solr core? What is a Solr collection? What is SolrCloud? What is the purpose of solrconfig.xml? What is the purpose of managed-schema in Solr? Define analyzer in Solr? Describe tokenizer in Solr? What is a filter in the Solr analysis chain? What is an inverted index in Solr? How do you connect to Solr using SolrJ? List the ways to import data into Solr? What is the DataImportHandler in Solr? What are the types of Solr request handlers? How do you apply faceting in a Solr query? What is highlighting in Solr search results? What is the purpose of a query parser in Solr? What is the difference between stored and indexed fields in Solr? What is the difference between the standard query parser and DisMax? What is the difference between DisMax and eDisMax query parsers? What is the difference between q and fq parameters in Solr? What is the difference between soft commit and hard commit? Why is SolrCloud preferred over standalone Solr for production? How does Solr replication work in standalone (master-slave) mode? How does ZooKeeper coordinate a SolrCloud cluster? Why is leader election necessary in SolrCloud shards? What is the difference between NRT, TLOG, and PULL replicas in SolrCloud? When would you choose sharding over replication in SolrCloud? How does Solr handle distributed search across shards? Explain the execution flow of a Solr search request? Explain the lifecycle of a document from indexing to searchability in Solr? Why doesn't Solr return newly indexed documents without a commit? How do you troubleshoot slow Solr queries? How can you optimize indexing throughput in Solr? Explain the internal working of Solr's caching layers? How do you optimize faceted search performance on large collections? What happens when a Solr shard leader goes down? Which is better for autocomplete, EdgeNGram or the Suggester component, and why? How does Solr handle deep pagination, and why is cursorMark recommended over start/rows? Explain the execution flow of an atomic update in Solr? Why should you use docValues for sorting and faceting fields? How do you troubleshoot OutOfMemory errors in a Solr node? What is the difference between Solr's standard scoring and function queries? How does SolrCloud handle a split-brain or network partition scenario? Explain the internal working of Lucene segment merging in Solr? When should you use a custom similarity or scoring function in Solr? How do you optimize Solr for high-throughput near real-time indexing? What is the difference between Apache Solr and Elasticsearch? How do you secure a SolrCloud cluster in production?
Show more question and Answers...


Comments & Discussions