Searches and filtering on big database

koranthir · 2024-07-12T00:28:29.695Z

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?

GaryIreland · 2024-07-12T12:29:37.708Z

The AWS plugin tbh. Do it the costly way but pay a smaller fee to amazon.

koranthir · 2024-07-12T13:27:48.655Z

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.

msgiblin · 2024-07-12T14:35:39.961Z

Hi there,

Can you share how your database is structured, and how the advanced filtering is being applied?

koranthir · 2024-07-12T17:30:22.788Z

image682×673 30.7 KB

Previsao_api is the relational type with other table.

msgiblin · 2024-07-12T18:06:34.808Z

koranthir:

Previsao_api

Could you show how that table is structured and how they relate?

koranthir · 2024-07-12T18:08:16.160Z

previsao_api = previsao_test { route, parameters, and lots of other fields}
It is a one to many relation