We have a table with 100K+ records and the combined filter needs to search across 10+ columns. This can take a few seconds to return the results. Also this consumes precious database resources. We did optimize the table to only contain the needed data but the performance is not what we like. This functionality is used a lot in our application.
Therefor i would like the option to connect Azure Search to this table and let this index the table. The combined filter should send the query to the connected Azure Search instance en return the data to the grid.
