You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@solr.apache.org by "Mazen Raafat (Jira)" <ji...@apache.org> on 2021/04/19 01:28:00 UTC
[jira] [Created] (SOLR-15353) Querying multiple collection
performance issue
Mazen Raafat created SOLR-15353:
-----------------------------------
Summary: Querying multiple collection performance issue
Key: SOLR-15353
URL: https://issues.apache.org/jira/browse/SOLR-15353
Project: Solr
Issue Type: Bug
Security Level: Public (Default Security Level. Issues are Public)
Components: search
Affects Versions: 8.8.1
Environment: SolrCloud Setup: 3 zookeeper servers and 2 solr cloud nodes
each Solr node hosted in AWS m5.xlarge EC2 with 8G RAM dedicated to Solr JVM heap
in this environment each collection is one shard and 2 replicas
for benchmarking i've used JMeter, setting the thread group=50, and loop count=500
Reporter: Mazen Raafat
Attachments: querying alias points to collection 1 and collection 2.png, querying collection 1.png, querying collection 2.png, thread group.png
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:
# both collections have the same schema
# query and filter query are the same in all tests
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@solr.apache.org
For additional commands, e-mail: issues-help@solr.apache.org