Server side "or" filtering on large dataset

There are 25 000 records in a “Client” table, one of the fields is called “Type” which is a list.

A client can have more than one “type”, for instance “wholesale”, “factory” and “direct”. There are 9 client types.

Currently I use a multi select dropdown and intersect function to filter the data, it is very slow. I suspect the filtering is done client side.

Can someone suggest a more efficient way to apply the filter?

apply it server side it should be fairly quick < 1 second to return from the server

search for clients with constraints type = type

if you are doing
search for clients filtered to type list intersect with type list (filter selection) then that will be incredibly slow since it returns the full list of clients to the page then filters them on the client side using advanced filter

don’t do list to list filters

do list contains 1 thing filters