I’ve been struggling with this for a couple days filtering searches in big databases.
My data have a relational with another type and I can’t constraint the search. So I tried 2 things:
1 - Advanced Filtering: Worked great with 100 rows, but in live version, 2000 rows was too much and took minutes to filter.
2 - Nested Search: Really good speed and easy setup but melted a lot of WU’s with just a few clicks.
What is the best approach here?
The AWS plugin tbh. Do it the costly way but pay a smaller fee to amazon.
Yeah other services are much better than Bubble in database searches, but I was thinking in a native solution. I think I’m being too “newbie” with this problem not finding a solution to this.
Hi there,
Can you share how your database is structured, and how the advanced filtering is being applied?
Could you show how that table is structured and how they relate?
previsao_api = previsao_test { route, parameters, and lots of other fields}
It is a one to many relation
