This issue has been created
There are 5 updates.
 
 
XWiki Platform / cid:jira-generated-image-avatar-5785f328-69d1-4620-86c1-0bcf36569a47 XWIKI-23791 Open

XAR export executes many database queries on large wikis even when exporting just a single page

 
View issue   ยท   Add comment
 

Issue created

 
cid:jira-generated-image-avatar-a511871d-fb73-4af3-870f-aca825bbb424 Michael Hamann created this issue on 04/Dec/25 13:51
 
Summary: XAR export executes many database queries on large wikis even when exporting just a single page
Issue Type: cid:jira-generated-image-avatar-5785f328-69d1-4620-86c1-0bcf36569a47 Bug
Affects Versions: 16.10.0
Assignee: Unassigned
Components: Filter - Instance
Created: 04/Dec/25 13:51
Labels: performance
Priority: cid:jira-generated-image-static-major-2f49d63c-c1a7-4f02-bea3-a8c9bed571c1 Major
Reporter: Michael Hamann
Description:

Steps to reproduce:

  1. Have a lot of spaces nested inside a common root space (like, 200k spaces).
  2. Perform a XAR export of a single page that is also in that root space.

Expected result:

The export is fast and when checking a trace, e.g., on Glowroot, only a few export-related database queries are shown.

Actual result:

The export is slow and checking database queries shows 200k queries of

SELECT DISTINCT xwikidocum0_.XWD_NAME AS col_0_0_
    FROM xwikidoc xwikidocum0_
   WHERE xwikidocum0_.XWD_WEB = ?
ORDER BY xwikidocum0_.XWD_NAME ASC
 
 

5 updates

 
cid:jira-generated-image-avatar-a511871d-fb73-4af3-870f-aca825bbb424 Changes by Michael Hamann on 04/Dec/25 13:51
 
Fix Version: 17.10.1
Fix Version: 18.0.0-rc-1
Fix Version: 16.10.16
Fix Version: 17.4.8
Assignee: Michael Hamann