This issue has been created
 
 
Blog Application / cid:jira-generated-image-avatar-516da1e6-45b8-4f68-94f3-7de3a6d30ac3 BLOG-220 Open

The 'All Blogs Panel' is very slow on large wikis

 
View issue   ยท   Add comment
 

Issue created

 
cid:jira-generated-image-avatar-c9fa26ab-a5d1-47a9-a297-2982ae858a7a Mohamed Boussaa created this issue on 02/Jul/24 10:55
 
Summary: The 'All Blogs Panel' is very slow on large wikis
Issue Type: cid:jira-generated-image-avatar-516da1e6-45b8-4f68-94f3-7de3a6d30ac3 Bug
Affects Versions: 9.13.9
Assignee: Unassigned
Created: 02/Jul/24 10:55
Priority: cid:jira-generated-image-static-major-18e62990-def7-4129-b964-50c1de0c552a Major
Reporter: Mohamed Boussaa
Description:

We noticed that on large wikis the with lots of blogs and blogs posts the 'All Blogs Panel' (Blog.AllBlogsPanel) panel takes a long time to load and sometimes it doesn't even load as the server returns a connection timeout error.

We are reproducing on an XWiki instance with the following amount of data :

  • Total number of pages : 258083
  • Number of blogs : 262
  • Number of blog posts : 37470

When checking the code of the panel we can see that there is no limit applied on the XWQL query used to get the list of blogs pages available on the wiki, so, the panel is listing all existing blog pages which is causing the slowness when there is a lot of blogs.

So, to fix the issue, the panel should be improved to paginate the query results.

The {{documentTree /} macro, which has pagination, could be used with the "filterByClass" parameter to only return blog pages.