Filter sql based on C# List instead of a filter table
Personally I can see two tricks you can pursue. And one “blast from the past” more. Route #1. Use GTT: GLOBAL TEMPORARY TABLE GTTs were introduced in FB 2.1 (and u use it) and can be per-connection or per-transaction. You would want the per-transaction one. This difference is about the data(rows), the schema(structure and indexes, … Read more