# Server side "or" filtering on large dataset

**URL:** <https://forum.bubble.io/t/server-side-or-filtering-on-large-dataset/357584>\
**Category:** Questions\
**Created:** [January 29, 2025, 3:06am UTC](https://forum.bubble.io/t/server-side-or-filtering-on-large-dataset/357584 "2025-01-29T03:06:32Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![HennieScheepers](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/henniescheepers/32/173914_2.png) [@HennieScheepers](https://forum.bubble.io/u/HennieScheepers)\
**Post date:** [January 29, 2025, 3:06am UTC](https://forum.bubble.io/t/server-side-or-filtering-on-large-dataset/357584/1 "2025-01-29T03:06:32Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![mitchbaylis](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/mitchbaylis/32/122860_2.png) [@mitchbaylis](https://forum.bubble.io/u/mitchbaylis)\
**Post date:** [January 29, 2025, 6:20am UTC](https://forum.bubble.io/t/server-side-or-filtering-on-large-dataset/357584/2 "2025-01-29T06:20:01Z")

</div>

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
