Agent253 opened a new issue #423:
URL: https://github.com/apache/solr-operator/issues/423
Hi,
I have a problem with my Solr database. I have a core with around 50
millions documents (split in 4 shards) and it's extremely slow.
It takes around 50 seconds for 1000 new documents to be committed and I
frequently get this error:
> Task queue processing has stalled for 20195ms with 0 remaining elements to
process.
(When I get this error, my documents aren't committed)
In read mode, a simple query takes a long time:
- With a `q=*:*` and `rows=10`, it takes 776ms to get a response (Maybe
it's because I didn't use the shard key ?)
- When I filter a simple id like that `objectId: 1234` and shard key
`_route_=abcd!`, it takes around 100ms to get a response
My schema and config core :
- I have the indexes only for each field I filter (the description is not
filtered so I didn't set an index on it)
- I have enabled the `LazyFieldLoading` to lazy load some not indexed
fields (like a description with a big string)
- My core is split in 4 shards and I set the shard key on the id like this:
`abcd!1234` (So the shard key is `abcd!`)
- I set this filterCache :
```xml
<filterCache class="org.apache.solr.search.CaffeineCache" maxRamMB="1000"
autowarmCount="128"/>
```
If anyone has an idea why Solr is so slow, I'd greatly appreciate it
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscr...@solr.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@solr.apache.org
For additional commands, e-mail: issues-h...@solr.apache.org
