Uploaded image for project: 'Solr'
  1. Solr
  2. SOLR-15354

Querying multiple collection performance issue

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Duplicate
    • Affects Version/s: 8.8
    • Fix Version/s: None
    • Component/s: search
    • Environment:

      Description

      performance degradation when querying multiple collections using aliases that points to multiple collection or calling the search handler directly with  collection query param as follow

      http://localhost:8983/solr/collection1/select?collection=collection1,collection2,collection3

       

      in the first test i have queried a collection with about 40k docs, the throughput was ~3k req/sec

      in the second test  i have queried another collection with about 4k docs, the throughput was ~3.5k req/sec

      in the third test i have queried an alias that points to both collections and viola! the throughput dropped to be ~200 req/sec!

      i have tried not to use alias and use solrurl/solr/collection1/select?collections=collection2 and got the same result

       

      notes:

      1. both collections have the same schema
      2. query and filter query are the same in all tests 

        Attachments

        1. querying alias points to collection 1 and collection 2.png
          549 kB
          Mazen Raafat
        2. querying collection 1.png
          521 kB
          Mazen Raafat
        3. querying collection 2.png
          539 kB
          Mazen Raafat
        4. thread group.png
          505 kB
          Mazen Raafat

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              mazen_raafat Mazen Raafat
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: