This issue has been created
 
 
XWiki Platform / cid:jira-generated-image-avatar-f6d7e076-4f91-49c6-9e48-b279220cdd37 XWIKI-22926 Open

Make it possible to configure the batch size in the Solr index synchronization on startup

 
View issue   ยท   Add comment
 

Issue created

 
cid:jira-generated-image-avatar-c01d317a-3378-4b55-8bf5-5a6f969aefce Michael Hamann created this issue on 24/Feb/25 15:45
 
Summary: Make it possible to configure the batch size in the Solr index synchronization on startup
Issue Type: cid:jira-generated-image-avatar-f6d7e076-4f91-49c6-9e48-b279220cdd37 Improvement
Affects Versions: 15.10
Assignee: Unassigned
Components: Search - Solr
Created: 24/Feb/25 15:45
Labels: performance
Priority: cid:jira-generated-image-static-critical-9a610421-e829-40bc-a9e2-de4bea10ca86 Critical
Reporter: Michael Hamann
Description:

The index synchronization on startup currently uses a batch size of 100 documents. On big wikis, as noted in XWIKI-18817, this leads to a huge load on the database as the query performance is poor. While waiting for a proper solution, a huge improvement would already be if it was possible to increase the batch size such that less of these expensive queries are performed when there is enough memory. Additionally, the default should be increased to 1k to bring at least a 10x improvement.