Sam we need to look into how we can speed up here.
Can you find and email me the areas that are slow so I can help you figure out a solution. Maybe use the index more and not SQL
This issue is a follow up to #1545
#2158 updated code to improve cmis performance
Fixed, tested on master 2.5 // postgres