Known Issue: indexing performance impact of queries with "Add results to search"

PocketQuery results can be added to the Confluence search index by:

• Enabling indexing globally in the PocketQuery configuration (Confluence Admin > PocketQuery > Configuration)

• Enabling the “Add results to search” option on a query in the PocketQuery administration

In general, we advice leaving indexing disabled globally, especially if you have queries with large results. If you need the feature, we recommend only setting the “Add results to search” option on queries with manageable result sizes.

Unfortunately, using the indexing feature can have a significant performance impact on your indexing performance, especially with large query results.

Be aware of the following when the feature is enabled:

• Whenever you perform a global re-index of your Confluence instance, any time a PocketQuery macro is found linked to a query with the “Add results to search” option set, the linked query is executed.

• Whenever you update a page with a PocketQuery macro linked to a query with the “Add results to search” option set, the linked query is executed.

• The PocketQuery index job will re-index all pages containing PocketQuery macros linked to queries with the “Add results to search” option set. This will trigger an execution of the linked queries so that the PocketQuery results in the search index stay up-to-date. By default, the PocketQuery index job is run once every night.

This implementation is due to how indexing in Confluence works for apps with the Extractor2 module.

If you have any questions or concerns, please reach out to us.