We’ve implemented FTS against a table that has an Access Group SQL Constraint for the majority of our users when reading from the database. The constraint is complicated and consists of a couple of joins to other tables so we need to keep it as a SQL Constraint.
The FTS configuration includes a couple of child tables that are compositions.
Performance for the FTS in this situation can sometimes be very slow and sits for what seems like forever before returning. I don’t see the same performance issues when there is no SQL Constraint so my assumption here is that the two aren’t playing nice together, and the FTS is iterating though matches to find results that the user has access to. Are there any suggestions on what I can do to improve the performance here?