Thanks Torsten

I have checked the query plans and as you say, the join seems to bring back all the products first and them filter them.

That is why I did the user functions as the query have parameters, but I wasn't aware of the 100ms roundtrip minimum.

We have decided to move the product details over to the main database. It's just too much of a performance sacrifice for now.

Thank you for your input.

Kind Regards