Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

time to return confluence search result

Ollie Guan Community Leader Dec 12, 2021

Hi Community,

we just upgraded to Confluence Data Center v7.13, our database is about 400GB, and the attachment is 1.5TB.

When we query in Confluence, the time to return results of different orders of magnitude

1. returns 4000 results, about 0.5 seconds;

2. returns 40000 results, about 1-2 seconds;

3. returns 400,000 results, about 4-6 seconds;

I want to know whether the system is possible to optimize?

1 answer

0 votes

There's a couple of things you might look at here. 

The Confluence search mostly works from the index, and that is built for searching over delivering content, so one thing is that you can optimise searches by looking for things that are easier to index and search than others.  One simple example is searching for labels rather than just words - there's a lot more distinct words in the body text of your pages than there are distinct label words and phrases.  Another one is Confluence prioritises the age of pages (last update, not creation), so if you can limit your search to an updated range, it'll go faster!

Optimising the search system is completely different of course.  You're looking to optimise what gets indexed and read out during the search process.  Good use of labels can help again, but there is a part of it that jumps out - restrictions (on view) impose load on searches.  Again, it's not this simple, but if you imagine your search as a series of "narrowing down" searches, the first narrowing is "person can see space", the second "page matches word" and third "is page restricted".  The fewer things you can check for restrictions, the better.

All that said, your numbers look quite responsive to me!

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Confluence Cloud

🏠 Say hello to the new Confluence Home!

Hi Atlassian Community, My name is DJ Chung, and I’m a Product Manager on the Confluence Cloud team. Today, I’m excited to share a new and improved version of Home. The new Home helps you ...

37,937 views 27 124
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you