Bitbicket Server API - Project search slow

[Sandro Herrmann [Communardo]]

I have created some testdata in my local Bitbucket server installation:

• 30000 projects
• 3 repositories for each project
• 1000 of the projects are visible for users of group stash-users

System is well sized:

• 8 GB for the Java process
• 4 core i7 CPU
• PostgresSQL on the same host
• Bitbucket v5.16.0

If I now use the bitbucket server API to search for Projects it is very slow. 

search = projectService.findAll(new PageRequestImpl(0, 50));

This call alone takes up to 20 seconds if used as a normal bitbucket user who is able to see the 1000 projects. When logged in as admin it only takes less than a second.

Am I missing some hidden cache parameter here which I might need to increase for better performance? 

[Gonchik Tsymzhitov]

Hi! 

did you check the dbms side? 

Maybe db is slow ?