Performance issue with Table Excerpt Include (50 Pages, ~2min Load Time)

[seadeang]

Hello,

I am currently using Confluence to aggregate multiple individual pages into a single final page using the Table Excerpt and Table Excerpt Include macros.

Functionally, it works as expected. However, I am facing a significant issue with performance.

The loading time of the final page is extremely slow. I have tried several approaches to improve the performance, but none of them have provided a satisfactory result.

I would like to know if there are any features or best practices within Confluence that could help resolve this issue in my current setup.

< Current Setup >
- There are 50 individual pages, and each page contains a table.
- The final page aggregates all 50 tables into a single table using Table Excerpt Include (loading time is approximately 2 minutes).
- The final page must reflect updates in real time whenever it is accessed.
- The "Output cached results" option in Table Excerpt Include cannot be used because it does not support real-time updates.
- We are not allowed to use additional add-ons.

Any suggestions or recommendations would be greatly appreciated.

Thank you!

[Kris Klima _K15t_]

@seadeang 

You may be able to ease the pressure by using page include only - yes, it would create 50 sections on the target page with 50 tables.

I don't know what's your exact use case but I'd ask if a fragmented table isn't better navigable than a giant amalgamated one - especially within the confines of a single Confluence page.

[seadeang]

@Kris Klima _K15t_ 

Thanks for the suggestion! I'll weigh the pros and cons of fragmented vs. amalgamated tables for our specific workflow. Navigability is definitely a priority, so I'll keep this in mind during my testing.

[Arkadiusz Wroblewski]

Hello @seadeang 

Are you using Confluence Server or Cloud ?

[seadeang]

Hi, I’m using Confluence Data Center. (self-hosted)

[Arkadiusz Wroblewski]

@seadeang 

I don't see here really a solution. That's heavy setup and unfortunately this behavior are expected, especially when you not accepting Caching.

[Arkadiusz Wroblewski]

@seadeang  @Kris Klima _K15t_ 

Wouldn’t it be easier to first use MultiExcerpt to build the huge table as you need, then copy that result to a new page and use MultiExcerpt on that table only? In the end, you would have one big table to Multiexcerpt on a single page instead of 50 separate pages. That would probably reduce the load.

[seadeang]

@Arkadiusz Wroblewski 

Thanks for the advice! I'll try using Multi-Excerpt as you suggested and test if the 'Output cached results' option improves the loading speed.