I think the answer is probably No.  Although it's hard to say for sure without knowing your implementation.  If I can assume that when you look up data in the...

It looks like the query optimizer is timing out.  You can look at this post to determine how to verify that and get some suggestions for how to avoid it.

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/troubleshoot-optimizer-timeout-performance

I...

I'm investigating a problem that's kind of similar to this. Maybe you've already done this but I would suggest looking at a trace.

We have a front end...