# Multi Filters using Relations: a new way šŸ’” **URL:** \ **Category:** Ask for Help\ **Created:** [December 18, 2021, 11:32pm UTC](https://community.glideapps.com/t/multi-filters-using-relations-a-new-way/36092 "2021-12-18T23:32:34Z")\ **Posts on this page:** 1\ **Showing post:** 8
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [January 21, 2022, 8:41pm UTC](https://community.glideapps.com/t/multi-filters-using-relations-a-new-way/36092/8 "2022-01-21T20:41:39Z")
Hola Eden! My original idea was to create a kind of ā€œSQL Queryā€ inside Glide although the big troubles came from playing/working with parameters using an OR operator and AND operator at the same time (a hard challenge sometimes in GDE). In the end, a Filter is almost a SQL Query when you try to narrow your useful data. When I ended this idea, I evaluated if this had been a good solution ( a clever idea) or on the contrary, it might create more load/work for Glide (unnecessarily) due to use of template columns changing dynamically along with relations based on them. To sum up: the endless dilemma between Efficiency vs. Effectiveness when our APP is using this method with a large amount of data: 15k or 20k+ rows šŸ˜• I donā€™t know at the end whether the best option is to load all data once and let Glide filter and discard values/rows automatically or create/use a dynamic relation to get a specific result always (my idea). Which process is better for Glide? ā€¦ I donā€™t know yet I read @Darren_Murphy and @Jeff_Hager discuss about this issue here and I agree with some points but I think the friends @Mark or @Jason can give us the final answer to have the best performance on our APPs always. > [@Fixing load times from large sheets](https://community.glideapps.com/t/fixing-load-times-from-large-sheets/37287/5): > > Iā€™m in a similar situation and have been trying to find better ways to make things more efficient and faster. I have a large-ish table with a handful of relations linking to other tables along with some several computationsā€¦and relations in those other tables linking back to the large table. One thing Iā€™ve learned is that any relations that rely on computed columns, such as templates, will take longer to build initially. In my case, I did have one particular column that was built from a vlookā€¦ Have a nice weekendā€¦ feliz fin de semana! --- _[View the full topic](https://community.glideapps.com/t/multi-filters-using-relations-a-new-way/36092)._