There is 1 comment.
 
 
XWiki Platform / cid:jira-generated-image-avatar-f8e0d613-ca8e-49bd-9841-b71cc95b51c5 XWIKI-18817 Open

Missing database indexes for the query used by Solr indexing to get all documents

 
View issue   ยท   Add comment
 

1 comment

 
cid:jira-generated-image-avatar-5f491aad-7a7f-4bb6-90ec-dbb641c1db2b Thomas Mortagne on 26/Nov/24 19:21
 

CREATE INDEX solr_iterate_all_documents ON xwikidoc (XWD_WEB, XWD_NAME, XWD_LANGUAGE, XWD_VERSION);

Unfortunately, it's not really possible anymore to create such an index. Since the XWD_WEB and XWD_NAME field moved to 768 characters, an index containing both would be bigger than the maximum 3072 bytes allowed by MySQL/MariaDB.