Im quite new to bubble and really happy so far with everything you can do with it. Im building my first product and have a question regarding search-functionality. Im building a kind of social media app where people can create posts and also search through posts. Now I finished the search functionality for my app but now I heard of backend workflows for the first time and how they enable a better performance.
Currently im doing the search in normal workflows, for example:
The user can search for all posts that are have a special categorie attribute. The results are displayed in a repeating group.
But thinking of how there could be potential 100k posts to search through, could I get performance issues down the road by placing the search functionality in normal workflows but not in backend workflows?
just a note that it is a typical beginner mistake to ensure you build everything to scale already now.
you will not.
your database will change over time
your app idea will change.
search should be handled when several users all complain search is slow not after.
as an fyi, many people eventually offload search to apis like algolia or xano, which perform especially complex searches faster.
for basic searches, and you should do everything possible to make your database optimal for basic searches, bubble is fine
what is a basic search
do a search for with 3 constraints
what is not a basic search
do a search for: filtered:advanced where name contains A or last name contains B
or do a search for: nested do a search for
change your database in such a way that you do not use advanced searches. by adding the right fields to the datatype you are searching instead of needing to search through 2+ datatypes.
note you can still do that 1 year later using backendworkflows, which allow you to change 10,000 rows in your database within 10 minutes.
Unfortunatly for my app I needed the not basic search option.
Regarding the point you make about changing the database in a way that I dont need advanced searches I have a question to an example:
Like mentioned before I got Posts and all Posts can have 3 different Categories. Currently I made a option set for the Categories and Posts have a Datatype of “Categories” which is a list of Categories. Users can search for different Categories. For example the categorie “game” and “tutorial”. Now I want all posts to show that have either “game” or “tutorial” in their category list.
I currently have a filtered and advanced search that does this : “This Post-Categories intersect with Multidropdown-Categories value:count > 0”
It works fine but as you said I should try to handle this without filtered-advanced-method. How is this possible to do without it?